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

130 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
choanae123686(None) 
choana1138441choana_
chance134617092ch_ance
change124116752ch_ange
cloacae1145232cloacae
cabana103913563cabana_
cabanas112413033cabanas
canal75428043c__anal
canape10913523c__anape
cane66653123c__an_e
canoe75627253c__anoe
carinae94318593carinae
catenae9311373catenae
cetane8315283cetan_e
chadar1239353ch_adar
chaetae1238603chaetae
chafe135117353ch_a_fe
chaine115119223ch_aine
chaise114916413ch_aise
chalah143511663ch_alah
chalazae2244423chalazae
chamade15138453ch_amade
chanced154113213ch_anced
chancel144011773ch_ancel
chancer144215633ch_ancer
chances145218093ch_ances
chancre14348783ch_ancre
chancy164010863ch_ancy
chang115418563ch_an_g
changed144214143ch_anged
changer134215543ch_anger
changes134517583ch_anges
changs125215373ch_angs
channel123910483ch_annel
chant105932693ch_an_t
chantage1446633ch_antage
chanted134015953ch_anted
chanter123919733ch_anter
chantey154112543ch_antey
chants115020393ch_ants
chanty145215823ch_anty
chape125221143ch_a_pe
charade13129913ch_arade
charas114223613ch_aras
chare105231983ch_a_re
charge125114213ch_arge
chase105127123ch_a_se
chasse115114603ch_asse
chaste114617393ch_aste
chazan20269133ch_azan
cheapie1437563cheapie
chelae113614603ch_elae
chianti1236613chianti
chicane1489553chican_e
china105022483ch_ina_
chinas115119403ch_inas
chine105231723ch_in_e
choice132010523cho_ice
choke145118023cho__ke
chola104718033cho_la_
cholas114818003cho_las
cholate122114933cholate
choline122915383choline
cholla113911023cholla_
chollas123811353chollas
chon96627793cho_n__
choose115116143cho_ose
chopine143512263chopine
choral115118493cho_ral
chorale124313353chorale
chordal13449883chordal
chordate1448033chordate
chore105126763cho__re
chorea115216093chorea_
choreal124412223choreal
choreas124414203choreas
chorial124214143chorial
chorine123218363chorine
chortle124210443chortle
chose105925403cho__se
chouse116017563cho_use
chowse144711753cho_wse
chutnee1246833chutnee
cicadae1244853cicadae
cleanse9358723cleanse
cloaca1037263cloaca_
cloacal1135163cloacal
cloacas1136233cloacas
clonal8310913clo_nal
clone75728163clo_n_e
coala77521123c_oala_
coalas87418963c_oalas
coannex1635513c_oannex
coarse84813903c_oarse
coatee84327223c_oatee
coaxal15387303c_oaxal
cognac1157273c_ognac
cognate10312203c_ognate
cohune1189423cohun_e
coinage10310553c_oinage
comae97128423c_o_mae
comanage1346343comanage
cone67256963c_o_n_e
conge85227593c_o_nge
connate9315753c_onnate
conte76633203c_o_nte
cornea84018933c_ornea
coronae94214893coronae
costae85319683c_ostae
cottae84615703c_ottae
coxae146115183c_o_xae
crane75331603c_ran_e
crone75231333cro_n_e
cyanate12259703c_yanate
echidnae1442903echidnae
hance105424153_h_ance
hanse85722793_h_anse
hoagie102310013_hoagie
hoarse94411323_hoarse
honan85319773_ho_nan
hone77549323_ho_n_e
khanate1437073kh_anate
ochone11311293ocho_n_e
phonal11310383pho_nal
phonate12411813phonate
phone105621933pho_n_e
shone83725983sho_n_e
thanage11117943th_anage
thane86122533th_an_e
zonae145116443_zo_nae

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271305.87322820.9
3Display Results1301300.0333939.4
 (SQL Overall)1786911306.31228309.7
 
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.