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

102 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
algerine981028(None) 
algerines1069081algerines
alexine142410542al_exine
altering91917112altering
angering102113802angering
anserine8313082anserine
lagering102212312lagering
tangerine1048402tangerine
acarine9316003a_carine
adenine8311213a_denine
adhering1338883adhering
adulterine1143773adulterine
aedine73218393a__edine
aerie54634603a__eri_e
ageing84213403a_ge_ing
agene65621583a_ge__ne
agenize172910153a_genize
alanine7316863al_anine
albertite1146123albertite
alcidine1148233alcidine
aldermen1145043aldermen
aldrin7311243al_drin_
aldrins8310203al_drins
alerting91312383al_erting
aleurone846113aleurone
alevin92511513al_evin_
alevins102110573al_evins
alewife1344923al_ewife
alexin132311483al_exin_
alexines15258503al_exines
alexins141910663al_exins
algaecide1352293algaecide
algicide1245563algicide
algin65718763alg__in_
algins74816433alg__ins
algorism1147353algorism
aliening91510893aliening
aline57243153al___ine
alizarine1845353alizarine
alkaline12168283alkaline
alkene104114003alke__ne
alkine104916803al__kine
alleging1038473alleging
allergen9135883allergen
allergin9136303allergin_
allergins10146383allergins
alluring939073alluring
alpine84417373al__pine
alterant8614963alterant
alterity1149843alterity
alumine9412693al_umine
alvine94614583al__vine
amberina1247393amberina
angeling102811733angeling
anguine839913ang_uine
ankerite1248923ankerite
anserines9411293anserines
apocrine1246933apocrine
argentine1047893argentine
arginine948563arginine
atabrine1045203atabrine
aubergine1244763aubergine
auguring1036383auguring
badgering1436963badgering
ballerina1146483ballerina
blueline1036873blueline
daggering13246113daggering
dangering12239303dangering
eserine7415903_eserine
faltering132211113faltering
ferine96422583__ferine
figurine1245603figurine
fleering123811283fleering
fluorine1147813fluorine
glycerine1544703glycerine
haltering132212003haltering
laagering1136833laagering
larine63927043_l_arine
laterite8716333laterite
laterize17613293laterize
latrine7715123_latrine
layering122310353layering
leering83417643_leering
lierne638023_lier_ne
margarine1247713margarine
olefine1038023ol_efine
oleine6313793ol_e_ine
paltering122612893paltering
passerine1147083passerine
pelerine10313013pelerine
piperine122011833piperine
riverine11310803riverine
rogering10310273rogering
saggering12197793saggering
serine65432673__serine
tangerines1147543tangerines
ulcering1139333ulcering
uterine7315193_uterine
viperine13189713viperine
vomerine1347683vomerine
wagering13219523wagering
wolverine1554343wolverine

Search took 10 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.326548131.9
2DLD Change Limit1461621029.45315462.0
3Display Results1021020.0333090.9
 (SQL Overall)1786911029.81218211.5
 
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.