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

189 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
fruitier113658(None) 
fruiter10309681fruit_er
bruiter93710632bruit_er
crustier10259532crustier
faultier1135282faultier
flutier103011552flu_tier
frettier1156592frettier
fritter103912772fr_itter
frontier1147312frontier
frostier1148162frostier
fruited11389092fruit_ed
fruiterer1243332fruiterer
fruiters11328172fruit_ers
fruitiest1237382fruitiest
fruitily1445142fruitily
fruiting12229062fruiting
fruition11106102fruition
fruitlet1146882fruitlet
frumpier1534172frumpier
fustier104213932f_ustier
runtier73512852_runtier
rustier74416362_rustier
ruttier73412282_ruttier
trustier8268682trustier
acuities10312443acuities
arbiter939933arbit_er
artier63419733ar__tier
brainier102510223brainier
brattier1047663brattier
brinier93613463br_inier
bruiser9349573brui_ser
bruited104110353bruit_ed
bruiters10329133bruit_ers
bruiting11259973bruiting
brushier13306973brushier
bustier93916153_bustier
courtier1059313courtier
craftier1376193craftier
critter94113033cr_itter
crucifier1644313crucifier
cruddier1244153cruddier
crudities1247733crudities
cruiser93410433crui_ser
crumbier1456363crumbier
crummier1435603crummier
draftier1285263draftier
driftier1275123driftier
druggier11134833druggier
drumlier1134523drumlier
dustier83814133_dustier
equities17310773equities
fattier103513463f_attier
fatuities1246913fatuities
feistier1136193feistier
ferities111416713ferities
fitter94120033f__itter
fixities1838213fixities
flauntier1243063flauntier
flintier1136393flintier
flirtier1144883flirtier
flitter103413903f_litter
floatier1136983floatier
fluffier13264333fluffier
fluidizer2242643fluidizer
flukier14397853flu_kier
fluster103913063flust_er
fluter95316863flu_t_er
flutter104012093flu_tter
flytier13356503f_lytier
footier104115113f_ootier
fortifier1546233fortifier
fortuities1346303fortuities
frailer10319943frai_ler
frailties1245853frailties
frater94520593fr_at_er
freakier15246483freakier
fretter103412753fr_etter
frier85225843fr___ier
friller104111743fr_iller
frillier1136513frillier
fringier1236543fringier
frisker14389273fr_isker
friskier1535193friskier
frites94922483fr_it_es
fritted113611333fr_itted
fritters113810783fr_itters
fritzes19329453fr_itzes
frizer184011283fr_i_zer
frizzer18446893fr_izzer
frizzier19284813frizzier
froggier1354643froggier
fronter103611583front_er
frontiers1254993frontiers
frother133110153fr_other
frothier1435953frothier
frouzier2043703frouzier
frowsier1444893frowsier
frowstier1553143frowstier
frowzier2343313frowzier
fructify1942353fructify
fruit85122223fruit___
fruitage1244343fruitage
fruitages1344483fruitages
fruiterers1343003fruiterers
fruitful1443553fruitful
fruitiness1345993fruitiness
fruitions12106103fruitions
fruitless1244163fruitless
fruitlets1243173fruitlets
fruitlike1642853fruitlike
fruits94512493fruit__s
fruity12429693fruit__y
fubsier12367763f_ubsier
fuggier12348963f_uggier
fumier11310903f_u_mier
funkier14349983f_unkier
funnier103210163f_unnier
furmities1447523furmities
furrier103513643f_urrier
further1337003f_urther
furzier19318093f_urzier
fusilier1135413fusilier
fussier103610673f_ussier
fuzzier18256523f_uzzier
goutier82612353gou_tier
grainier9218893grainier
grimier103210433gr_imier
gripier103210323gr_ipier
gritter83913353gr_itter
grittier9316263grittier
grottier9316673grottier
groutier9297173groutier
grubbier13344753grubbier
gruffier1544703gruffier
grumpier1334803grumpier
grungier1034983grungier
grunter83110783grunt_er
guiltier934493_guiltier
gustier83813863_gustier
guttier83911103_guttier
jauntier1535233jauntier
juicier1635463_juicier
lustier73813503_lustier
mitier83620673__mitier
mustier94017953_mustier
nuttier73112023_nuttier
orbiter937853orbit_er
pitier84019823__pitier
poutier93215323pou_tier
prettier1069043prettier
pricier113313113pr_icier
privier122910453pr_ivier
purifier1338563purifier
purities10316283purities
purtier93214093_purtier
puttier93314503_puttier
quitter162910753_quitter
rainier71614253_rainier
rattier74015593_rattier
reifier103414523_reifier
rentier73618223_rentier
ribier84414233_r_ibier
rimier83916273_r_imier
ritter63822413_r_itter
ritzier16297203_r_itzier
roilier7311523_roilier
rootier74915393_rootier
rubier84814743_ru_bier
ruddier9338523_ruddier
ruiner64013643_rui_ner
rulier65016353_ru_lier
rummier11309563_rummier
runnier74010113_runnier
rushier103411973_rushier
rustler73512343_rustler
sluttier836453sluttier
smuttier1035213smuttier
squintier1844473squintier
suiter64121813_suit_er
triter65120593tr_it_er
troutier8277143troutier
truster73114313trust_er
trusties82712853trusties
tuftier1096603_tuftier
vaultier1144293vaultier
whitier133311063_whitier
wristier1136863wristier
writer94416513wr_it_er
writher134010853wr_ither

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.1731032896.0
2DLD Change Limit1461621897.17020385.2
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.42324072.6
 
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.