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

180 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
subfiles13171072(None) 
subfile122010501subfile_
subfixes20207491subfixes
jubiles16289372jub_iles
subfield1444752subfield
subfields1543302subfields
sublimes12310032sublimes
sublines10315782sublines
subrules1039722subrules
subsales10310122subsales
subsides11410822subsides
subsites10312782subsites
subtile91912622subtile_
subtiler10208572subtiler
subtilest1148812subtilest
subtitles1156852subtitles
suffices16208182suffices
suffixes21196352suffixes
sulfides1238052sulfides
sulfites1139902sulfites
audiles83112613au_diles
biles75542143__b_iles
bubales113513343bub_ales
bubbies103913513bubbi_es
bubbles104315963bub_bles
bubblies1166773bubblies
cubbies133312883cubbi_es
cubicles1435883cubicles
defiles114016843_defiles
duffles14308923du_ffles
files85441273___files
fulfills1443653fulfills
fulfils1345723fulfil_s
guiles73919283gu__iles
gunfires1235063gunfires
hubbies143211563hubbi_es
hubrises1337103hubrises
huipiles1344423huipiles
jubile152910263jub_ile_
jubilee16298293jub_ilee
jubilees17244423jub_ilees
misfiles133110983misfiles
mobiles112813123mob_iles
muffles153910453mu_ffles
nubbles113412433nub_bles
nubile83212713nub_ile_
outfires1139863outfires
outflies11310153outflies
outwiles1139233outwiles
prefiles133113443prefiles
profiles133211233profiles
purfles122511843purf_les
refiles104122423_refiles
rubbies114114113rubbi_es
rubbles113715113rub_bles
rubies84420343rub_i_es
rubles83921703rub__les
ruffles133512273ru_ffles
rutiles74315843ru_tiles
sabines94318483sab_ines
sables85026693sab__les
sawflies1444743sawflies
scuffles16287863scuffles
seniles72618023s_eniles
sextiles1537643sextiles
shuffles17297783shuffles
similes92915233s_imiles
skiffles18265713skiffles
smiles84522293s__miles
snaffles14246043snaffles
sniffles14257723sniffles
snuffles14318413snuffles
soubises10107993soub_ises
souffles14298123souffles
spiles84227913s__piles
stabiles10311403stabiles
stifles103013393stif_les
stiles64328773s__tiles
stubbles1236843stub_bles
subbases1239063subbases
subbings13238483subbings
subcells1246283subcells
subcodes1338143subcodes
subcults1246933subcults
subcutes1238583subcutes
subduces1397263subduces
subdues1099893sub_dues
suberises11813453suberises
suberizes20811833suberizes
subfamilies1852483subfamilies
subfix1835073subfi__x
subframes1645853subframes
subfuscs1543753subfuscs
subidea1037533sub_idea
subideas1146443sub_ideas
subitem1138553sub_item
subitems1245493sub_items
sublates10315003sublates
sublet82827243sub__let
sublets92616703sub__lets
sublime11310363sublime_
sublimed1337213sublimed
sublimer1237613sublimer
sublimers1345773sublimers
sublimest1346713sublimest
subline9316893subline_
submiss1138083submi_ss
submits1139753submi_ts
subniches1665153subniches
suboxides1944993suboxides
subraces12313033subraces
subrings11229883subrings
subrule939643subrule_
subsale9310543subsale_
subscales1347343subscales
subseres10312423subseres
subside10410453subside_
subsided1257663subsided
subsider1138243subsider
subsiders1246053subsiders
subsidies1248423subsidies
subsists1037993subsists
subsite9412873subsite_
subskills1543773subskills
subsoiled1245453subsoiled
subsoiler1145323subsoiler
subsoilers1244063subsoilers
subsoils1076653subsoil_s
subsumes1246923subsumes
subtilely1444953subtilely
subtilin1047123subtilin
subtilins1147173subtilins
subtilizes2166873subtilizes
subtilties1246113subtilties
subtilty1345453subtilty
subtitle1046603subtitle_
subtitled1244713subtitled
subtle82113433sub_tle_
subtler92910843sub_tler
subtlest10511363sub_tlest
subtones10311383subtones
subtribes1346233subtribes
subtypes1544553subtypes
subvenes1339633subvenes
subvirus1344333subvirus
subzones1947223subzones
suckles134516743su_ckles
suffice15197573suffice_
sufficed17205663sufficed
sufficer16225823sufficer
sufficers17204533sufficers
suffixed22214343suffixed
suffuses1435833suffuses
suicides1139083suicides
suites63727403su__ites
sulfates11310793sulfates
sulfide1138103sulfide_
sulfids1137293sulfi_ds
sulfite10310473sulfite_
sulfones1147683sulfones
sulkies114315763sulki_es
sullies74122233sulli_es
sunfishes1547033sunfishes
sunrises8310693sunrises
supines94216383su_pines
supples11511283su_pples
supplies1268833supplies
surfaces1338673surfaces
surfier102613543surfi_er
surfiest112414433surfi_est
surfings12268073surfings
surmises10310643surmises
surtitles945633surtitles
survives1436333survives
suspires1038203suspires
tubfuls1245483tubful_s
tubules9310233tub_ules
unfixes17238113_unfixes
unpiles92112783_unpiles
uppiles11208263_uppiles

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621806.15623743.0
3Display Results1801800.0802250.0
 (SQL Overall)1786911806.65626846.6
 
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.