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

253 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
unfixes1723811(None) 
infixes17238131infixes
unfixed18218561unfixed
unmixes16197751unmixes
affixes2035502affixes
fixes154723592__fixes
gunfires1235062gunfires
infixed18206562infixed
nixes124519622_n_ixes
refixes174813172refixes
subfixes20207492subfixes
suffixes21196352suffixes
unboxes16208302unboxes
undies73821962undi_es
undines8716082undines
unfired112212452unfired
unfits93910292unfi_ts
unfix15429032unfix__
unfixt16398422unfix_t
unfrees1048642unfrees
unifies102714712unifies
unites65024852un_ites
unlives102010952unlives
unmixed17228212unmixed
unpiles92112782unpiles
unsexes14248922unsexes
unties64326922unti_es
admixes1765963admixes
affines1339483affines
affixed2134123affixed
affixer2033913affixer
affixers2143293affixers
animes84719593an_imes
anises64826693an_ises
annexes1437203annexes
antefixes1944333antefixes
aunties73920073aunti_es
bemixes18338653bemixes
bonfires1367383bonfires
bunnies94415003bunni_es
confides14310573confides
confines13315653confines
defies104624053defi_es
defiles114016843defiles
defines114118683defines
dunites8313593dun_ites
dunnites947173dunnites
endites83717063endites
endives113710693endives
enfaces122110913enfaces
engines81114463engines
ensiles72714833ensiles
entices91616333entices
entires71517783entires
envies9314053envi_es
faxes155726653__faxes
fices106031163__fices
fifes114822393__fifes
files85441273__files
fines86644263__fines
fires85740753__fires
fives116027363__fives
fixed165416953__fixed
fixer154717833__fixer
fixers165112983__fixers
foxes156321093__foxes
funnies104113603funni_es
gunfire1134743gunfire_
gunites8313123gun_ites
gunnies83413123gunni_es
hafizes2235983hafizes
helixes1739133helixes
hunkies143214503hunki_es
immixes1835073immixes
incises93414893incises
incites93218483incites
indexes15339453indexes
indices103513443indices
indies73822783indi_es
indites83618983indites
infares10313023infares
infidel1146043infidel
infidels1244123infidels
infirms1245563infirms
infix15337773infix__
influxes1844343influxes
infuses102711873infuses
insides8512653insides
intines7921113intines
invites103915813invites
junkies183711693junki_es
knifes136210213kn_ifes
knives13458553kn_ives
kunzites2143243kunzites
lunies64723013lun_i_es
maxixes1535253maxixes
mixes147224403__mixes
naives94914223_naives
nides65229133_n_ides
nines55937343_n_ines
nites55736343_n_ites
nixe115722023_n_ixe_
nixed135714223_n_ixed
nixies135313873_n_ixies
noises65021853_noises
nudies75217093nudi_es
offices1536243offices
onyxes1654603on_yxes
outfires1139863outfires
outfoxes1836743outfoxes
panmixes1934913panmixes
pixes144323173__pixes
prefixes20389233prefixes
punkies134216803punki_es
punties94520783punti_es
radixes15259343radixes
refiles104122423refiles
refines105426343refines
refires104820313refires
refixed183611153refixed
remixes164313873remixes
sixes124526363__sixes
snipes83917393sn_ipes
subfiles131710723subfiles
suffices16208183suffices
suffixed22214343suffixed
sulfides1238053sulfides
sulfites1139903sulfites
sunfishes1547033sunfishes
sunrises8310693sunrises
tunnies73614263tunni_es
uglies7412323ugli_es
umpires1137813umpires
unaided92414603unaided
unaimed102812493unaimed
unaired82916013unaired
unais53420773unai__s
unakites1237543unakites
unaxed144113093un_axed
unbales92914863unbales
unbinds10267353unbinds
unboxed17249573unboxed
uncages103213773uncages
uncakes133012743uncakes
uncases93516553uncases
unciae83215313unciae_
uncials92510523uncials
uncinus937403uncinus
uncles8317163un_cles
undine7817263undine_
undoes73917403un_does
uneases73316263uneases
unfaded123111733unfaded
unfairer11184283unfairer
unfairest1243563unfairest
unfaiths1443213unfaiths
unfaked153211173unfaked
unfazed20299053unfazed
unfed94614223unf__ed
unfences1337933unfences
unfilled1298383unfilled
unfilmed1495803unfilmed
unfished15218293unfished
unfit84518563unfi__t
unfitly1335573unfitly
unfitness1244843unfitness
unfitted1238163unfitted
unfixing1935683unfixing
unflexed1935263unflexed
unfoiled12249723unfoiled
unfolds11146803unfolds
unfree9413203unf_ree
unfreed11510123unfreed
unfurls1035573unfurls
unfused11319513unfused
ungirds9105303ungirds
unglues836993unglues
ungues7412123un_gues
unhinges12266723unhinges
unhired112512153unhired
unifaces1346393unifaces
unified112413573unified
unifier102211863unifier
unifiers11237173unifiers
unions64216753un_ions
uniques1667443uniques
unisex1358353un_isex
unisexes1554613unisexes
unite54828383un_ite_
united74421543un_ited
uniter64619143un_iter
uniters73814173un_iters
unities72520153unities
unitizes1739133unitizes
units54923433un_i_ts
unkinks10265413unkinks
unlaces92513623unlaces
unlades82612833unlades
unlike102614063unlike_
unliked122411283unliked
unlined82515803unlined
unlinks11307403unlinks
unlive92712333unlive_
unlived112511373unlived
unmakes132810793unmakes
unmined102612953unmined
unmiter9310393unmiter
unmiters1037073unmiters
unmitres1036863unmitres
unmix14388973unmix__
unmixt15378703unmix_t
unoiled82415483unoiled
unpicks1545183unpicks
unpile81914323unpile_
unpiled102312743unpiled
unpins82312383unpi_ns
unrigs7159003unri_gs
unrimed102211633unrimed
unripe82012093unripe_
unriper9188283unriper
unripest1046083unripest
unrips8199453unri_ps
unrisen7229283unrisen
unrobes9269733unrobes
unsexed152410253unsexed
unsized172510543unsized
untaxed152710583untaxed
untidies939813untidies
untie54425493unti_e_
untied73720813unti_ed
untimed102713373untimed
untired82316383untired
untunes72211253untunes
untwines1137603untwines
unvexed18147103unvexed
unvoices13125163unvoices
unwaxed18308393unwaxed
unwinds11286733unwinds
unwise9510803unwise_
unwiser1037123unwiser
unwisest1165123unwisest
unwishes14147483unwishes
unwits9389893unwi_ts
unyokes1466733unyokes
unzips17175273unzi_ps
updives1334713updives
uppiles11208263uppiles
uprises92012733uprises
upsides10319633upsides
upsizes18297163upsizes
uptimes1177553uptimes
ureides8311103ureides
urines64724123u_rines

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 Filter1786911340270.393454684.5
2DLD Change Limit1340272536.59320328.7
3Display Results2532530.0763328.9
 (SQL Overall)1786912537.06225303.2
 
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.