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

145 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
unmixing183554(None) 
unfixing1935681unfixing
admixing1944132admixing
bemixing20226522bemixing
immixing2043542immixing
infixing1936102infixing
mixing164713942__mixing
nixing143311492_n_ixing
remixing182810332remixing
unboxing1836112unboxing
ungiving1346332ungiving
uniting8315822un_iting
unliving1248192unliving
unmaking1538132unmaking
unmewing1485912unmewing
unmitring1245262unmitring
unmoving1436252unmoving
unpiling1139752unpiling
unsexing1686852unsexing
unsmiling1256872unsmiling
untieing938862untieing
untiring9312002untiring
admiring1236133admiring
affixing2264333affixing
annexing1635473annexing
antiking13412073antiking
anviling1239743anviling
bemiring13239603bemiring
commixing2345193commixing
demising122012523demising
enditing10311073enditing
engining1039293engining
ensiling9410723ensiling
enticing11311803enticing
fixing174813783__fixing
fulmining1554403fulmining
incising11411093incising
inciting11312533inciting
indexing1737123indexing
inditing10312113inditing
inviting1239733inviting
knifing1536483kn_ifing
limiting1138813limiting
maxing164817073__maxing
miking134218463__miking
miming114317263__miming
mining94225453__mining
miring93723803__miring
nailing83419963_nailing
niding83217983_n_iding
nimming12358143_nimming
noising83615173_noising
numbing12269033num_bing
premixing2157803premixing
pumicing1535843pumicing
refixing19329793refixing
remising112516453remising
smiling103915443_smiling
smiting103014443_smiting
snailing92912973snailing
sniping103712053sn_iping
suffixing2343473suffixing
summiting1445793summiting
surmising1247683surmising
umping114815333u_m_ping
umpiring1336093umpiring
unabiding1345203unabiding
unageing1036273unageing
unaging9510933un_aging
unamusing1254203unamusing
unarming1138623unarming
unbaling11310683unbaling
unbeing1039373un_being
unbinding1336513unbinding
unbowing1436993unbowing
uncaging1268713uncaging
uncaking1539463uncaking
uncaring11312843uncaring
uncasing11511003uncasing
uncoiling1238993uncoiling
undaring10412753undaring
undoing9312243un_doing
undying1238503un_dying
unending10239943unending
unerring9311273unerring
unfading1347693unfading
unfailing1337453unfailing
unfitting1336423unfitting
ungazing1936033ungazing
ungirding1245153ungirding
ungluing1035863ungluing
unhairing1335953unhairing
unhinging1436093unhinging
unifying1537553unifying
unitizing1947803unitizing
unkinking1334783unkinking
unlacing1148653unlacing
unlading1058863unlading
unlaying1258363unlaying
unlinking1436273unlinking
unloving1277483unloving
unmanning1245873unmanning
unmasking1635263unmasking
unmeaning1237953unmeaning
unmeshing1595933unmeshing
unmingling1443453unmingling
unmitering1345003unmitering
unmix14388973unmix___
unmixed17228213unmix_ed
unmixes16197753unmix_es
unmixt15378703unmix__t
unmolding1335823unmolding
unmooring1255813unmooring
unnailing1037023unnailing
unpaying1456943unpaying
unpicking1834883unpicking
unpinning1245623unpinning
unpitying1544043unpitying
unrigging1245183unrigging
unripping1434643unripping
unrobing1138063unrobing
unsaying1288153unsaying
unseeing988293unseeing
unsewing1287433unsewing
unsling8313643un_sling
unstring9312093unstring
untidying1445473untidying
untuning937943untuning
untwining1346303untwining
untying1138943un_tying
unveiling1337723unveiling
unvoicing1545083unvoicing
unwaning1238133unwaning
unwilling1337163unwilling
unwinding1435843unwinding
unwinking1735073unwinking
unwishing1635593unwishing
unwitting1335583unwitting
unyoking1636183unyoking
unzipping2342703unzipping
updiving1534223updiving
uppiling1335853uppiling
uprising1138953uprising
upsizing2035413upsizing
vomiting1437733vomiting

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.420425454.8
2DLD Change Limit1461621457.65619091.2
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.13921954.9
 
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.