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) 
bilbies114712332_bilbies
tribes85119022tri_b_es
trilobites1244372trilobites
trilogies1048162trilogies
trollies8310232trollies
alibies9313323ali_bies
bailies94120203bail_ies
bilboes114410233_bilboes
billies93923503_billies
bribees11409283bri_bees
bribes105918533bri_b_es
brinies93317913bri_nies
brionies10310543brionies
brollies1039533brollies
brulyies1343423brulyies
brulzies1933983brulzies
brumbies1436533brumbies
chilies124218303chil_ies
chillies134113473chillies
dailies84219263dail_ies
dillies84122153_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
rabies85226013_r_abies
rallies73823343_rallies
relies65036423_rel_ies
ribbier1137583_ribbier
ribbiest1237583_ribbiest
ribes75530173_ri_b_es
ribier84414223_ri_bier
ribiers9319753_ri_biers
riles55343643_ril__es
rilles64725503_ril_les
rubbies114114113_rubbies
rubies84420333_r_ubies
rugbies10339353_rugbies
silkies113715693_silkies
sillies73425073_sillies
stilbites1144823stilbites
tabbies112913503t_abbies
tailbones1155253tailbones
tailfins1135443tailfins
tailles72516463tail_les
tailpipes1373073tailpipes
talkies113415733t_alkies
tallies73624603t_allies
tellies73820503t_ellies
thimbles1536013thimbles
thirties1139723thirties
tibias839943t_i_bias
tidbits1035173t_idbits
tidies74721833t_i_dies
tilburies1144333t_ilburies
tildes74513963t_il_des
tiles55542103t_il__es
tillites8312823t_illites
timbres11249333t_imbres
titbits935793t_itbits
titties73617363t_itties
tizzies15287893t_izzies
tobies84521013t__obies
toiles63923513toil__es
trannies8415013trannies
treaties8316983treaties
trebles9311443tr_ebles
trellis739873trelli_s
trellises947023trellises
trembles1237353trembles
trendies9312213trendies
triable92515393triable_
triacids1146713triacids
triadics1146123triadics
triages82613793tri_ages
triazines1847543triazines
triazins1738343triazins
tribades1136883tribades
tribals9610743tri_bals
tribe74420263tri_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
trillers83613483trillers
trilling92815963trilling
trillion847963trillion
trillions947173trillions
trillium1046203trillium
trilliums1144333trilliums
trills64319853tril__ls
trilobed1144203trilobed
trilobite1144813trilobite
trindles93211683trindles
trines64132563tri__nes
trinities9313333trinities
triodes84012503tri_odes
trioses75015653tri_oses
trioxides1744473trioxides
trioxids1644443trioxids
tripes85324873tri__pes
triplanes1148803triplanes
triples94616873tri_ples
triplexes1844243triplexes
triplites1148283triplites
triploids1245883triploids
tripodies1246573tripodies
triposes1039973triposes
trippier1246623trippier
trippiest1336583trippiest
tripwires1443283tripwires
triremes1035523triremes
trisemes1036643trisemes
trisomes1039833trisomes
trisomies1147163trisomies
tritones83413443tritones
triunes74311383tri_unes
troilites948433troilites
troiluses944553troiluses
trollied935893trollied
trophies13413673trophies
troubles1057183troubles
trusties82712853trusties
tuilles72411923tuil_les
twibils1253113twi_bils
twinkies1535983twinkies
willies103920153_willies

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.1701051123.5
2DLD Change Limit1461621638.92316380.4
3Display Results1631630.0802037.5
 (SQL Overall)1786911639.17319480.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.