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

163 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
trilbies103769(None) 
bilbies114712342_bilbies
tribes85119022tri_b_es
trilobites1244382trilobites
trilogies1048172trilogies
trollies8310232trollies
alibies9313323ali_bies
bailies94120203bail_ies
bilboes114410243_bilboes
billies93923503_billies
bribees11409283bri_bees
bribes105918533bri_b_es
brinies93317913bri_nies
brionies10310543brionies
brollies1039533brollies
brulyies1343423brulyies
brulzies1933983brulzies
brumbies1436533brumbies
chilies124218303chil_ies
chillies134113483chillies
dailies84219263dail_ies
dillies84122163_dillies
doilies84017363doil_ies
dribbles13348393dribbles
fillies103420253_fillies
frailties1245853frailties
freebies1337873freebies
friaries11310083friaries
fribbles15287713fribbles
frillier1136513frillier
frilliest1237113frilliest
frisbees13295013frisbees
frizzies19315933frizzies
ghillies12408663ghillies
gillies84120963_gillies
girlies83013703girl_ies
gribbles13307363gribbles
grilles83715023gril_les
grilses8319153gril_ses
killies113318113_killies
kilties113014143_kilties
lilies63021413_lil_ies
oribis838833ori_bi_s
priories10312453priories
prissies101712003prissies
privies122414263pri_vies
rabbies113416053_rabbies
rabies85226023_r_abies
rallies73823343_rallies
relies65036423_rel_ies
ribbier1137593_ribbier
ribbiest1237583_ribbiest
ribes75530173_ri_b_es
ribier84414233_ri_bier
ribiers9319753_ri_biers
riles55343643_ril__es
rilles64725503_ril_les
rubbies114114113_rubbies
rubies84420343_r_ubies
rugbies10339353_rugbies
silkies113715693_silkies
sillies73425083_sillies
stilbites1144833stilbites
tabbies112913503t_abbies
tailbones1155263tailbones
tailfins1135443tailfins
tailles72516473tail_les
tailpipes1373073tailpipes
talkies113415733t_alkies
tallies73624603t_allies
tellies73820503t_ellies
thimbles1536023thimbles
thirties1139723thirties
tibias839953t_i_bias
tidbits1035183t_idbits
tidies74721833t_i_dies
tilburies1144343t_ilburies
tildes74513963t_il_des
tiles55542103t_il__es
tillites8312833t_illites
timbres11249353t_imbres
titbits935803t_itbits
titties73617363t_itties
tizzies15287893t_izzies
tobies84521023t__obies
toiles63923513toil__es
trannies8415013trannies
treaties8316983treaties
trebles9311443tr_ebles
trellis739873trelli_s
trellises947023trellises
trembles1237353trembles
trendies9312213trendies
triable92515393triable_
triacids1146723triacids
triadics1146133triadics
triages82613793tri_ages
triazines1847543triazines
triazins1738353triazins
tribades1136893tribades
tribals9610753tri_bals
tribe74420273tri_b_e_
tribunes1055853tribunes
tributes1047233tributes
trices84826333tri__ces
trichites1448883trichites
trickie132611033trickie_
trickier143010233trickier
trickiest1549023trickiest
trickles143013763trickles
trienes74118413tri_enes
trientes82812123trientes
tries55742813tr___ies
trifles103814823tri_fles
trikes105419493tri__kes
trilby1144973trilb__y
trilith10310513tril_ith
triliths1145953triliths
trilled84116313tril_led
triller74215893tril_ler
trillers83613493trillers
trilling92815963trilling
trillion847973trillion
trillions947183trillions
trillium1046203trillium
trilliums1144333trilliums
trills64319853tril__ls
trilobed1144203trilobed
trilobite1144813trilobite
trindles93211683trindles
trines64132563tri__nes
trinities9313343trinities
triodes84012503tri_odes
trioses75015653tri_oses
trioxides1744483trioxides
trioxids1644443trioxids
tripes85324873tri__pes
triplanes1148803triplanes
triples94616873tri_ples
triplexes1844253triplexes
triplites1148283triplites
triploids1245893triploids
tripodies1246573tripodies
triposes1039973triposes
trippier1246623trippier
trippiest1336583trippiest
tripwires1443283tripwires
triremes1035523triremes
trisemes1036643trisemes
trisomes1039833trisomes
trisomies1147163trisomies
tritones83413443tritones
triunes74311383tri_unes
troilites948433troilites
troiluses944553troiluses
trollied935893trollied
trophies13413673trophies
troubles1057203troubles
trusties82712853trusties
tuilles72411923tuil_les
twibils1253113twi_bils
twinkies1535983twinkies
willies103920153_willies

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 Limit1461621637.20320291.8
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.68623248.9
 
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.