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

127 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
unfetter113675(None) 
enfetter1145351enfetter
unfetters1244361unfetters
enfetters1244462enfetters
fetter94120382__fetter
infecter13229152infecter
infester11239432infester
insetter8218592insetter
netter63722022_n_etter
unbitter1046172unbitter
unfelted1279402unfelted
unfettered1443652unfettered
unfitted1238162unfitted
unletted9310312unletted
untether1145162untether
unwetted1238122unwetted
upsetter1034642upsetter
abetter958323_abetter
affecter1644523affecter
anteater8311603anteater
begetter11136313begetter
besetter10137973besetter
better84723703__better
buffeter1683593buffe_ter
defeater122611663defeater
effecter1664773effecter
enfettered1442483enfettered
enfever1344643enfe_ver
fatter94523213__fatter
feater95224053__feater
fester94723513__fester
fetted104817893__fetted
fetters103517903__fetters
fitter94120033__fitter
fretter103412753_fretter
getter74117613__getter
incenter102212093incenter
indenter92311443indenter
infected14229403infected
infecters14257583infecters
infector13478843infector
inferrer11217443inferrer
infested12249643infested
infesters12237703infesters
inflater1149893inflater
inputter1034203inputter
inserter82312133inserter
insetted9249023insetted
insetters9187133insetters
inventer112410843inventer
inverter112411073inverter
junketeer2042123junketeer
junketer1943713junke_ter
knitter11348133kn_itter
knotter11317643kn_otter
letter63722583__letter
lunette737483lun_ette_
lunettes836753lun_ettes
mofette1296773mofette_
mofettes1386083mofettes
natter64420743_n_atter
neater64424313_n_eater
nester64124183_n_ester
nether94014163_n_ether
netted74118713_n_etted
netters73618583_n_etters
nettier74211813_n_ettier
nettler7349503_n_ettler
neuter63713793_n_euter
nutter63918053_n_utter
outfitter1243913outfitter
petter83924773__petter
pinsetter1145013pinsetter
reletter81311023reletter
resetter81511833resetter
setter64023723__setter
surfeiter1244713surfeiter
tetter64322453__tetter
unabetted1244993unabetted
unbeaten1038013unbeaten
unbelted1179333unbelted
unbitted1138213unbitted
unbitten1045213unbitten
unclutter1143373unclutter
undented102313953undented
undotted1048523undotted
uneager839753un_eager
uneaten7412543un_eaten
unfairer11184283unfairer
unfasten1144843unfasten
unfeared121511013unfeared
unfelt92413463unfelt__
unfence1239193unfence_
unfenced1437733unfenced
unfences1337933unfences
unfettering1543703unfettering
unfluted1237173unfluted
unfolder12216583unfolder
ungotten944533ungotten
unhatted1238183unhatted
unheated121514553unheated
uniter64619143un__iter
unlettered1143953unlettered
unmatted1138293unmatted
unmelted1169183unmelted
unmiter9310393un_miter
unpitted1148623unpitted
unpotted11108393unpotted
unreeler8127293unreeler
unrented92413923unrented
unrested91914513unrested
unretire846963unretire
unseated91317683unseated
unsettle866063unsettle
unsettled1055213unsettled
unsettles964653unsettles
untented92613413untented
untested92612413untested
untethers1244153untethers
unvested122210223unvested
unwitted1237543unwitted
upsetters1143653upsetters
ureter6313203u_re_ter
utter54218763u___tter
vetter93417643__vetter
wetter93919443__wetter
whetter13348803_whetter

Search took 9 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 Limit1461621278.26617682.3
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.48521059.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.