Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “abalones” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
abalones103875(None) 
abalone938901abalone_
amarones10311352amarones
baloney1237482_baloney
baloneys1334662_baloneys
chalones13312172chalones
zabaiones2043002zabaiones
zabajones2742002zabajones
abacuses1235763abacuses
abandoned1342723abandoned
abandoner1242693abandoner
abandoners1342473abandoners
abandons1145353abandon_s
abases85720773aba__ses
abashes12510373aba_shes
abates85825033aba__tes
abatises10311013abatises
abators94413083abato_rs
abeles84719393abel__es
abioses9311493ab_ioses
ablates92416903ab_lates
ables75935543ab_l__es
ablings1038743ab_lings
ablins8316193ab_lin_s
abodes94417513ab__odes
aboves114512843ab__oves
absconds1343593absconds
absolves1344413absolves
acarines10314343acarines
acetones10310033acetones
agaroses938823agaroses
agones75719863__agones
airlines8312793airlines
alamodes1148013alamodes
alanines8314803alanines
albacores1343313albacores
alines65735223__alines
alkaloses13144853alkaloses
allonges937313a_llonges
aloes54933673__alo_es
alone55732963__alone_
amarone9311203amarone_
amazons1836653amazon_s
ambones11312683a_mbones
amidones11348663amidones
amylenes13105703amylenes
amyloses1347223amyloses
anagoges10187243anagoges
analogies101910643analogies
analogs82810453analo_gs
analogues10126183analogues
analyses11149963analyses
analytes11169203analytes
analyzes20157193analyzes
ancones93116343a_ncones
anemones10249473anemones
anilines8415143anilines
apagoges12144693apagoges
apolunes1045293apolunes
aquatones1844843aquatones
atones65225773__atones
axones134614513__axones
azlons154110423a_zlon_s
bacons104917583_bacon_s
balances1279973_balances
balases93815433_balases
balconies1347743_balconies
baldies105317703_baldies
baldness1137043_baldness
baleens938473_baleens
bales76250083_bal__es
ballies93725743_ballies
ballonet10314503ballonet
ballonets1146723ballonets
ballonnes1145323ballonnes
ballons93916963ballon_s
banes74945583_ba__nes
baroness101210063_baroness
baronet91022203_baronet
baronets101410903_baronets
barongs105310833_barongs
baronies10315023_baronies
baronnes1038553_baronnes
barons85025383_baron_s
batons85519423_baton_s
bayonet121212213_bayonet
bayonets13135583_bayonets
belongs10408223_belongs
belons84119413_belon_s
bizones1837823_bizones
blokes123813883_b_lokes
blondes104213163_b_londes
blonds95213343_b_londs
boloney1247763_boloney
boloneys1334503_boloneys
bones76446533_b__ones
bygones1335913_bygones
bylines1239243_bylines
cabezones2243783cabezones
cajones163311333_cajones
calzones1948763_calzones
cataloes10311653catalo_es
chalone12312103chalone_
clones84526563__clones
colones96124433_colones
cyclones1537483cyclones
doblones1136763doblones
etalons739073etalon_s
flavones1435833flavones
galores82614333_galores
halazones2145993halazones
haloes94623863_halo_es
halons95720713_halon_s
hyalines14169333hyalines
kalongs1255443_kalongs
malines93625603_malines
oblongs1033533ob_longs
opalines10311423opalines
pantalones1246723pantalones
pralines102217723pralines
sabatons1037843sabaton_s
sabayons1343963sabayon_s
salines74029413_salines
salons63823693_salon_s
spadones1137253spadones
tagalongs1142233tagalongs
taloned8310223_taloned
talons64019443_talon_s
valines104520213_valines
violones1137383violones
zabagliones235633zabagliones
zabaione1942793zabaione_
zabajone2642053zabajone_

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.483369960.7
2DLD Change Limit1461621337.89318517.9
3Display Results1331330.0632111.1
 (SQL Overall)1786911338.43921174.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.