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

146 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
unfixing193568(None) 
infixing1936101infixing
unmixing1835541unmixing
affixing2264332affixing
fixing174813782__fixing
nixing143311492_n_ixing
refixing19329792refixing
suffixing2343472suffixing
unboxing1836112unboxing
unfading1347692unfading
unfailing1337452unfailing
unfitting1336422unfitting
ungiving1346332ungiving
unifying1537552unifying
uniting8315822un_iting
unliving1248192unliving
unpiling1139752unpiling
unsexing1686852unsexing
untieing938862untieing
untiring9312002untiring
admixing1944133admixing
annexing1635473annexing
antiking13412073antiking
anviling1239743anviling
bemixing20226523bemixing
confiding1638333confiding
confining1539993confining
defiling132812463defiling
defining133711803defining
enditing10311073enditing
enfacing1467293enfacing
engining1039293engining
ensiling9410723ensiling
enticing11311803enticing
faxing175117053__faxing
fifing134212343__fifing
filing103823763__filing
fining104223213__fining
firing104021723__firing
fixings18347443__fixings
foxing175012433__foxing
immixing2043543immixing
incising11411093incising
inciting11312533inciting
indexing1737123indexing
inditing10312113inditing
infirming1545163infirming
infixion1843683infixion
infixions1943843infixions
infusing1237893infusing
inviting1239733inviting
knifing1536483kn_ifing
mixing164713943__mixing
nailing83419963_nailing
niding83217983_n_iding
noising83615173_noising
outfiring1338163outfiring
outfoxing20115603outfoxing
prefixing2246783prefixing
refiling123116533refiling
refining122416863refining
refiring123513923refiring
remixing182810333remixing
snailing92912973snailing
sniffing15227453sniffing
sniping103712053sn_iping
sufficing1844883sufficing
umpiring1336093umpiring
unabiding1345203unabiding
unageing1036273unageing
unaging9510933un_aging
unarming1138623unarming
unbaling11310683unbaling
unbeing1039373un_being
unbinding1336513unbinding
unbowing1436993unbowing
uncaging1268713uncaging
uncaking1539463uncaking
uncaring11312843uncaring
uncasing11511003uncasing
uncoiling1238993uncoiling
undaring10412753undaring
undoing9312243un_doing
undying1238503un_dying
unending10239943unending
unerring9311273unerring
unfearing1338883unfearing
unfeeling1337113unfeeling
unfencing1545953unfencing
unfilial1145343unfilial
unfix15429033unfix___
unfixed18218563unfix_ed
unfixes17238113unfix_es
unfixt16398423unfix__t
unfolding1436063unfolding
unfreeing1345103unfreeing
unfurling1335763unfurling
ungazing1936033ungazing
ungirding1245153ungirding
ungluing1035863ungluing
unhairing1335953unhairing
unhinging1436093unhinging
unitizing1947803unitizing
unkinking1334783unkinking
unlacing1148653unlacing
unlading1058863unlading
unlaying1258363unlaying
unlinking1436273unlinking
unloving1277483unloving
unmaking1538133unmaking
unmewing1485913unmewing
unmitring1245263unmitring
unmoving1436253unmoving
unnailing1037023unnailing
unpaying1456943unpaying
unpicking1834883unpicking
unpinning1245623unpinning
unpitying1544043unpitying
unrigging1245183unrigging
unripping1434643unripping
unrobing1138063unrobing
unsaying1288153unsaying
unseeing988293unseeing
unsewing1287433unsewing
unsling8313643un_sling
unsmiling1256873unsmiling
unstring9312093unstring
untidying1445473untidying
untuning937943untuning
untwining1346303untwining
untying1138943un_tying
unveiling1337723unveiling
unvoicing1545083unvoicing
unwaning1238133unwaning
unwilling1337163unwilling
unwinding1435843unwinding
unwinking1735073unwinking
unwishing1635593unwishing
unwitting1335583unwitting
unyoking1636183unyoking
unzipping2342703unzipping
updiving1534223updiving
upfling1337093upf_ling
uppiling1335853uppiling
uprising1138953uprising
upsizing2035413upsizing

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.403443402.0
2DLD Change Limit1461621466.26623326.2
3Display Results1461460.0632317.5
 (SQL Overall)1786911466.73226543.5
 
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.