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

193 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
unifying153755(None) 
deifying1637632deifying
edifying1636082edifying
ignifying1744312ignifying
knifing1536482knif_ing
minifying1845822minifying
purifying1835852purifying
reifying1539382reifying
reunifying1745162reunifying
sniffing15227452sniffing
uglifying1743962uglifying
undying1238502un_dying
unedifying1843722unedifying
unfixing1935682unfixing
uniting8315822uni_ting
unlaying1258362unlaying
unpaying1456942unpaying
unpitying1544042unpitying
unsaying1288152unsaying
untidying1445472untidying
untying1138942un_tying
vinifying1944712vinifying
aerifying1636493aerifying
annoying1246543annoying
basifying1845073basifying
biffing163510013_biffing
brutifying1943413brutifying
carnifying1945043carnifying
chivying2034973chivying
citifying1845383citifying
codifying1944953codifying
coiffing1755933coiffing
coifing133213893coif_ing
cornifying1944813cornifying
crucifying2143513crucifying
dairying1336353dairying
damnifying2043623damnifying
dandifying1974313dandifying
defying15328823_defying
densifying1844813densifying
dignifying1944153dignifying
drifting13338733drifting
dulcifying2043193dulcifying
enisling949633enisling
enjoying1935003enjoying
enskying1633283enskying
envying1435713en_vying
fancifying2243883fancifying
fifing134212343_fif_ing
gasifying1744523gasifying
gifting123810893_gifting
grifting13299263grifting
hinnying15124853hinnying
infixing1936103infixing
inlaying1247893inlaying
inlying1168153in_lying
justifying2444053justifying
knitting13257023knitting
lifting113313273_lifting
lignifying1843523lignifying
magnifying2044033magnifying
miffing16298403_miffing
modifying1944663modifying
mummifying2042853mummifying
mutinying1545333mutinying
naffing14359033_naffing
nazifying2543473nazifying
nibbing12339553_nibbing
niching133612433_niching
nicking143516323_nicking
nidifying1744223nidifying
niding83217983_ni_ding
nighing123410063_nighing
nilling83619563_nilling
nimming12358143_nimming
nipping123412873_nipping
nixing143311493_ni_xing
notifying1645623notifying
nullifying1743493nullifying
ossifying1644253ossifying
pacifying2045503pacifying
pitying132910243_pitying
punishing1545383punishing
qualifying2643973qualifying
quantifying2743213quantifying
ramifying1855603ramifying
rarifying1646313rarifying
ratifying1656823ratifying
riffing144011273_riffing
rifling112815013_rifling
rifting113515003_rifting
russifying1743923russifying
salifying1636333salifying
shifting152910383shifting
sifting113014593_sifting
signifying1844413signifying
snafuing1235083snafuing
snibbing13295893snibbing
snicking153610233snicking
sniffling1644093sniffling
sniping103712053sni_ping
snipping13308853snipping
snuffing15256803snuffing
spiffing17237083spiffing
spiffying2142753spiffying
stiffing15248703stiffing
stifling122110913stifling
stimying1437503stimying
tidying1238513_tidying
tiffing14339383_tiffing
trifling122411503trifling
tumefying1842423tumefying
typifying2143323typifying
unageing1036273unageing
unaging9510933un_aging
unarming1138623unarming
unbaling11310683unbaling
unbeing1039373un_being
unbinding1336513unbinding
unbowing1436993unbowing
unboxing1836113unboxing
uncaging1268713uncaging
uncaking1539463uncaking
uncaring11312843uncaring
uncasing11511003uncasing
uncloying1555813uncloying
uncuffing1843703uncuffing
undaring10412753undaring
undoing9312243un_doing
unending10239943unending
unerring9311273unerring
unfading1347693unfading
unfitting1336423unfitting
ungazing1936033ungazing
ungirding1245153ungirding
ungiving1346333ungiving
ungluing1035863ungluing
unhinging1436093unhinging
unicycling1862843unicycling
unific1137463unif_i_c
unified112413573unif_ied
unifier102211863unif_ier
unifies102714713unif_ies
uniforming1643793uniforming
unify113611113unify___
unitizing1947803unitizing
unkinking1334783unkinking
unlacing1148653unlacing
unlading1058863unlading
unlinking1436273unlinking
unliving1248193unliving
unloving1277483unloving
unmaking1538133unmaking
unmewing1485913unmewing
unmitring1245263unmitring
unmixing1835543unmixing
unmoving1436253unmoving
unpicking1834883unpicking
unpiling1139753unpiling
unpinning1245623unpinning
unrigging1245183unrigging
unripping1434643unripping
unrobing1138063unrobing
unseeing988293unseeing
unsewing1287433unsewing
unsexing1686853unsexing
unshifting1743863unshifting
unsling8313643un_sling
unstring9312093unstring
untieing938863untieing
untiring9312003untiring
untuning937943untuning
unvarying1644503unvarying
unwaning1238133unwaning
unwilling1337163unwilling
unwinding1435843unwinding
unwinking1735073unwinking
unwishing1635593unwishing
unwitting1335583unwitting
unyoking1636183unyoking
unzipping2342703unzipping
updrying1534013updrying
upfling1337093u_pfling
uplifting1534963uplifting
verifying1936413verifying
vilifying1944493vilifying
vivifying2243843vivifying
waifing142910893waif_ing
whiffing2134703whiffing
wifing133513393_wif_ing
yuppifying2442443yuppifying
zincifying2843253zincifying
zinkifying3042683zinkifying

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621937.14020470.9
3Display Results1931930.0802412.5
 (SQL Overall)1786911937.62623431.8
 
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.