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 “allonges” 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.

126 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
allonges93731(None) 
allonge837021allonge_
alleges84212572all_eges
allonyms1344362allonyms
ballonnes1145322ballonnes
gallonages1264562gallonages
longes75925572__longes
abalones1038753abalon_es
ablings1038743abling_s
agones75719863a_gon_es
agonies83016623a_gonies
alcoves1297883alco_ves
aldoses8311203aldo_ses
alienages1045973alienages
alienees8118653alienees
alimonies1198333alimonies
alines65735223a_lin_es
alkanes113812933alkan_es
alkenes114212753alken_es
alkines114415733alkin_es
alkynes14336463alkyn_es
allanites949803allanites
allees64521483all__ees
allege74314653all_ege_
alleged9389323all_eged
alleger8319633all_eger
allegers9378233all_egers
alleles73812033all_eles
allergen9135893allergen
allergens10145173allergens
allergies10137783allergies
alliances11107103alliances
allies63827673all__ies
allobars1046583allobars
allocates11410473allocates
allods73615083allo__ds
allonym1244733allon_ym
allots64019173allo__ts
allotted986873allotted
allottee887123allottee
allottees964323allottees
allotter866473allotter
allotters965563allotters
allotypes1445103allotypes
allover1038583allo_ver
allovers1137673allovers
allowances1543823allowances
allowed111610083allo_wed
allows94517683allo__ws
alloxans1545243alloxans
alloyed11158033allo_yed
alloys94014563allo__ys
alludes83610333all_udes
allures72913113all_ures
almonds10127953almon_ds
almoner949383almon_er
almoners1068133almoners
almonries1156933almonries
aloes54933673a_lo__es
alone55732963a_lon_e_
along65419493a_long__
alpines94016193alpin_es
ambones11312683ambon_es
ancones93116343ancon_es
anlages82414113anl_ages
arranges939413arranges
astonies8815113astonies
atlantes838553atlantes
atones65225773a_ton_es
atonies75320953a_tonies
avenges1157543a_venges
axones134614513a_xon_es
azlons154110423azlon__s
balconies1347753balconies
ballonet10314503ballon_et
ballonets1146723ballonets
ballonne1045243ballonne_
ballons93916963ballon__s
belonged1235313belonged
belongs10408223belong_s
blondes104213163_blondes
blunges104212223_blunges
callings113613833calling_s
calloses10313393callo_ses
callouses1147683callouses
calzones1948763calzon_es
challenges1643993challenges
clones84526563_clon_es
colognes11310603colognes
colones96124433colon_es
colonies103620013colonies
conges94928173__conges
felonies11310993felonies
flanges113413273_flanges
flongs105010493_flong_s
gallonage1164453gallonage_
gallons83015953gallon__s
gallowses1374953gallowses
halloes104021523hallo__es
kalongs1255443kalong_s
klongs11436603_klong_s
larynges1244503larynges
leones64417723_leon_es
lodges86820153__lodges
loges66534203__lo_ges
longe66626463__longe_
longed87121373__longed
longer75823203__longer
longers84819543__longers
longest84114953__longest
longies82916553__longies
longs65527063__long_s
loonies73919543_loonies
lounges84811353_lounges
lunges76123423__lunges
mallings113413093malling_s
melanges1138613melanges
oblongs1033533oblong_s
oolongs845953oolong_s
plunges104011613_plunges
prolonges12337923prolonges
salpinges1244523salpinges
splodges1234153splodges
sponges10311043_sponges
tallages92312003tall_ages
ullages838953ull_ages

Search took 8 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.420425454.8
2DLD Change Limit1461621267.19020328.5
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.65623340.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.