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

169 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
unfixt1639842(None) 
unfit84518561unfi_t
unfix15429031unfix_
unmixt15378701unmixt
fixt1410729712__fixt
infix15337762infix_
unfelt92413462unfelt
unfits93910292unfits
unfixed18218562unfixed
unfixes17238112unfixes
ungirt71112712ungirt
unit45140072un_i_t
unlit55025462unli_t
unmix14388972unmix_
unvext1658172unvext
unwit84417522unwi_t
admixt1637333admixt
affix1836003affix_
anoint6423633anoint
befit105222663befi_t
bemixt174510363bemixt
bundist10310193bundist
confit113316403confi_t
engirt71112613engirt
enlist6417043enlist
fiat76646643__fiat
fist76248423__fist
fit66365453__fi_t
fix136236103__fix_
fixit154819303__fixit
funfest13348083funfest
gunfight1643493gunfight
gunfire1134743gunfire
gunflint1245943gunflint
indict93115563indict
infant92315133infant
infect113413443infect
infest93315433infest
infight1437453infight
infill938403infill
infirm1137033infirm
infixed18206563infixed
infixes17238133infixes
inflict1248623inflict
insist6314503insist
knit85728143kn_i_t
mixt136831913__mixt
neist54628443_neist
next116631083_n_ext
nit37065943_n_i_t
nix106932833_n_ix_
nixe115722023_n_ixe
nixy145714513_n_ixy
nudist73813323nudist
outfit93014943outfi_t
pundit92914183pundi_t
refit84230063refi_t
refix155212483refix_
remixt155014853remixt
snit46342473sn_i_t
subfix1835073subfix_
suffix1935233suffix_
sunfast1038503sunfast
sunfish1338883sunfish
sunlit61516103sunli_t
twixt155512483_twixt
unai44824783unai__
unais53420773unai_s
unapt710421593un_apt
unbelt83015693unbelt
unbent83216593unbent
unbid83214633unbi_d
unbind93011423unbind
unbolt83013893unbolt
unbox1438753unbox_
unbuilt948003unbuilt
uncast84215713uncast
unci65019463unci__
uncia75015163unci_a
unciae83215313unciae
uncial83715223uncial
uncini8310153uncini
uncut73219173un_cut
undid72415363undi_d
undies73821963undies
undine7817263undine
unfair936233unfair
unfaith1345783unfaith
unfed94614223unf_ed
unfired112212453unfired
unfitly1335573unfitly
unfitted1238163unfitted
unfixing1935683unfixing
unfold10179703unfold
unfond10149113unfond
unfree9413203unfree
unfurl937953unfurl
ungird887973ungird
ungot61718063un_got
unhat81119263un_hat
unhip10178823unhi_p
unhurt9311253unhurt
unific1137463unific
unified112413563unified
unifier102211863unifier
unifies102714713unifies
unify113611113un_ify
union54519793un_ion
unite54828383un_ite
units54923433un_its
unity84918493un_ity
unjoint1449233unjoint
unjust1337873unjust
unkent103116053unkent
unkept123710873unkept
unkind113310573unkind
unkink9308713unkink
unknit1068593unknit
unknot1037413unknot
unlet54133333un_let
unlike102614063unlike
unlink104011013unlink
unlive92712333unlive
unmeet83815743unmeet
unmet74426393un_met
unmixed17228213unmixed
unmixes16197753unmixes
unpent83117373unpent
unpick1446903unpick
unpile81914323unpile
unpin72613243unpi_n
unpins82312383unpins
unquiet16310663unquiet
unrent63219783unrent
unrest62918853unrest
unrig61711413unri_g
unrigs7159003unrigs
unrip72012863unri_p
unripe82012093unripe
unrips8199453unrips
unroot6315553unroot
unseat64221023unseat
unsent63820963unsent
unset54532433un_set
unsex123512633unsex_
unsexy16296903unsexy
unshift1387413unshift
unshut939013unshut
unsight1137483unsight
unspilt938853unspilt
untidy1059153untidy
untie54425493unti_e
untied73720813untied
unties64326923unties
until53517743unti_l
untwist1047713untwist
unwept11389813unwept
unwet84423173un_wet
unwind102610543unwind
unwise9510803unwise
unwish1239093unwish
unwits9389893unwits
unzip16207623unzi_p
unzips17175273unzips
upgirt9117263upgirt
uplift114610653uplift
uplit76020803upli_t
uptilt8410803uptilt
urtext1337433urtext

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161695.93618988.5
3Display Results1691690.0463673.9
 (SQL Overall)1786911696.12229188.3
 
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.