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 “truancy” 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
truancy124499(None) 
errancy1256362errancy
tenancy1237502tenancy
trance84718762tr_ance
tranny94210862tr_anny
truant6315782truan_t
truantly1144642truantly
truantry1142542truantry
truants738162truants
ardency1346483ardency
bouncy13409073bou_ncy
branch134014773br_anch
branchy17357913br_anchy
brandy124712063br_andy
branny115111833br_anny
brunch13329353bru_nch
chancy164010863_chancy
cranch133613533cr_anch
cranky153910633cr_anky
cranny114210273cr_anny
craunch1464443craunch
crunch13349503cru_nch
crunchy17324763cru_nchy
curacy1339593cura_cy
dormancy1644423dormancy
durance1059113durance
fancy134615483__fancy
fluency1545353fluency
franc104615413fr_anc_
francs114112193fr_ancs
granny104311163gr_anny
grungy11345973gru_ngy
guanay1037913_guanay
infancy1546173infancy
jouncy18336203jou_ncy
lunacy1136843_lunacy
mordancy1644193mordancy
nancy105214923__nancy
nuance859043_nuance
orangy105111233or_angy
organdy1254573organdy
piquancy2442973piquancy
pliancy1435593pliancy
prance104318573pr_ance
racy95825683_r_a_cy
rance75028513_r_ance
ranch105019793_r_anch
randy95022083_r_andy
rangy95320383_r_angy
raunch11358433_raunch
raunchy15284313_raunchy
ruana5312423_ruan_a
ruanas6311263_ruanas
runny84613483_ru_nny
runty86119043_ru_nty
tangy94519933t__angy
tansy84514933t__ansy
tetany959843tetan_y
tourney1036273tourney
trace75829613tr_a_ce
track114823013tr_a_ck
tract75635713tr_a_ct
trampy13499253tr_ampy
tranced104414173tr_anced
trances93919643tr_ances
tranche123312223tr_anche
trank96222423tr_an_k
tranks104017763tr_anks
tranq145416893tr_an_q
tranqs155210313tr_anqs
trans54933043tr_an_s
trashy12509053tr_ashy
tray77632593tr_a__y
treacly1237093treacly
treaty94414353trea_ty
trench114211613tr_ench
trendy10469603tr_endy
triac74116373tria_c_
triacs83913223tria_cs
triarchy1643613triarchy
trinary1039173trinary
trounce936823trounce
truancies1146883truancies
truanted935373truanted
truce75118693tru__ce
truck116115463tru__ck
truing73913933truin_g
truly84111553tru__ly
trunk94713043tru_n_k
trunks10429753tru_nks
trunnel745403trunnel
trusty94710113tru_sty
tunny86515033t_u_nny
turaco839453tura_co
turgency1444833turgency
twangy13386983t_wangy
twanky16445773t_wanky
tyranny1343063tyranny
unfancy1545203unfancy
urgency1345663urgency
vacancy1744443vacancy
verdancy1744723verdancy

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 Limit1340271026.01622278.4
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.45227695.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.