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

115 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
subfixes2020749(None) 
subfiles131710721subfiles
suffixes21196351suffixes
subfile122010502subfile_
subfix1835072subfix__
sublimes12310032sublimes
sublines10315782sublines
subsides11410822subsides
subsites10312782subsites
suffices16208182suffices
suffixed22214342suffixed
sulfides1238052sulfides
sulfites1139902sulfites
unfixes17238112_unfixes
affixes2035503_affixes
bubbies103913513bubbi_es
cubbies133312883cubbi_es
fixes154723593___fixes
gunfires1235063gunfires
hubbies143211563hubbi_es
hubrises1337103hubrises
infixes17238133_infixes
jubiles16289373jub_iles
outfires1139863outfires
outfoxes1836743outfoxes
prefixes20389233prefixes
refixes174813173_refixes
rubbies114114113rubbi_es
rubies84420343rub_i_es
sabines94318483sab_ines
sixes124526363s___ixes
soubises10107993soub_ises
spadixes1834113spadixes
subbases1239063subbases
subbings13238483subbings
subcodes1338143subcodes
subcutes1238583subcutes
subduces1397263subduces
subdues1099893sub_dues
suberises11813453suberises
suberizes20811833suberizes
subfield1444753subfield
subfields1543303subfields
subframes1645853subframes
subfuscs1543753subfuscs
subidea1037533sub_idea
subideas1146443sub_ideas
subitem1138553sub_item
subitems1245493sub_items
sublates10315003sublates
sublime11310363sublime_
sublimed1337213sublimed
sublimer1237613sublimer
sublimers1345773sublimers
sublimest1346713sublimest
subline9316893subline_
submiss1138083submi_ss
submits1139753submi_ts
subniches1665153subniches
suboxides1944993suboxides
subraces12313033subraces
subrings11229883subrings
subrules1039723subrules
subsales10310123subsales
subseres10312423subseres
subside10410453subside_
subsided1257663subsided
subsider1138243subsider
subsiders1246053subsiders
subsidies1248423subsidies
subsists1037993subsists
subsite9412873subsite_
subsumes1246923subsumes
subtexts1744903subtexts
subtile91912623subtile_
subtiler10208573subtiler
subtilest1148813subtilest
subtitles1156853subtitles
subtones10311383subtones
subtribes1346233subtribes
subtypes1544553subtypes
subvenes1339633subvenes
subvirus1344333subvirus
subzones1947223subzones
suffice15197573suffice_
sufficed17205663sufficed
sufficer16225823sufficer
sufficers17204533sufficers
suffix1935233suffix__
suffixal2142853suffixal
suffuses1435833suffuses
suicides1139083suicides
suites63727403su__ites
sulfates11310793sulfates
sulfide1138103sulfide_
sulfids1137293sulfi_ds
sulfite10310473sulfite_
sulfones1147683sulfones
sulkies114315763sulki_es
sullies74122233sulli_es
sunfishes1547033sunfishes
sunrises8310693sunrises
superfixes2246823superfixes
supines94216383su_pines
surfaces1338673surfaces
surfier102613543surfi_er
surfiest112414433surfi_est
surfings12268073surfings
surmises10310643surmises
surtaxes1536513surtaxes
survives1436333survives
suspires1038203suspires
tubifexes2151293tubifexes
unfixed18218563_unfixed
unmixes16197753_unmixes

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.406440125.6
2DLD Change Limit1461621156.81021462.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.26224606.3
 
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.