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

160 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
migrating1391053(None) 
emigrating1467501emigrating
misrating121014851misrating
disrating11714552disrating
grating93923182__grating
immigrating1743312immigrating
librating1239052librating
ligating102212282lig_ating
migraine1157862migra_ine
migration12179702migration
migrations13168682migrations
misdating131010662misdating
miseating121215432miseating
misgrading1546822misgrading
misgrafting1844082misgrafting
mismating141211822mismating
nitrating10312672nitrating
pirating11314512pi_rating
regrating111316212regrating
remigrating1547592remigrating
titrating10310112titrating
vibrating1537472vibrating
acierating1348313acierating
aerating92821003_aerating
aggrading1344843aggrading
agitating1138853agitating
airting83616303ai_r_ting
berating113220763_berating
bighting15269453big_hting
bogarting1334653bogarting
borating113414503_borating
crating103725203__crating
curating11314293_curating
degrading13137373degrading
denigrating14146923denigrating
derating103222283_derating
diagraming1544383diagraming
dictating1338883dictating
digesting12208673digesting
dighting142510843dig_hting
dilating102714903di_lating
disgracing1586743disgracing
emigration13228213emigration
emigrations14187153emigrations
engrafting1544183engrafting
engraving1446013engraving
fighting162710083fig_hting
filiating1339243filiating
filtrating1445973filtrating
fixating1936183fi_xating
fumigating1744653fumig_ating
gating84826953__g_ating
girting93113333gi_r_ting
gracing113216443__gracing
grading103918713__grading
grafting13319623__grafting
granting103514523__granting
gratin74520583__gratin_
gratine84719193__gratine
gratings103910763__gratings
gratins84119183__gratins
graving123114563__graving
graying124115883__graying
grazing183514553__grazing
gyrating1337453_gyrating
highting16259723hig_hting
hydrating1746323hydrating
ideating10311703_ideating
igniting1037363_igniting
imbruting1443773imbruting
imitating1238763imitating
imparting1437243imparting
ingrafting1544893ingrafting
iodating1038823_iodating
iterating10314253iterating
jigsawing2141933jigsawing
legating102313113leg_ating
liberating1349253liberating
lighting132811833lig_hting
liquating1946313liquating
macerating1549533macerating
mandating1339773mandating
marting103325013m_ar_ting
mating94832913m___ating
maturating13108573maturating
mediating13311203mediating
meliorating1446563meliorating
meriting11314683m_eriting
micturating1644883micturating
migraines1286933migra_ines
migrant10314313migra__nt
migrate101314173migrat__e
migrated121110513migrat_ed
migrates111112853migrat_es
migrational1444743migrational
migrator1147873migrat_or
migrators1247543migrators
migratory1545343migratory
militating1348823militating
milting103619123mi__lting
minting103020813mi__nting
minuting1139723mi_nuting
miring93723803mi_r__ing
mirroring1246193mirroring
misacting1439083misacting
miscasting1557073miscasting
misciting1439673misciting
miscreating1648493miscreating
misdrawing1745803misdrawing
misframing1846233misframing
misgrowing1744633misgrowing
mislaying1557913mislaying
mismaking18118023mismaking
misnaming1447423misnaming
mispaging1537803mispaging
misparting1538083misparting
misraising1348123misraising
misreading1448263misreading
misrelating1447273misrelating
misrouting1347223misrouting
misruling1237493misruling
missaying1537633missaying
misseating131310943misseating
misstating13129313misstating
mistaking1699693mistaking
misting103623383mi__sting
mistracing1569603mistracing
mistreating1449283mistreating
miswriting1646843miswriting
mitigating1447433mitigating
mitring103514143mitr__ing
moating104218153m__oating
moderating1448803moderating
mutating112211753m_utating
narrating10310353narrating
negating102012833neg_ating
nictating1237573nictating
nidating1039783ni_dating
operating12313723operating
orating83520323__orating
outrating10916403outrating
prating103424453__prating
prorating12314283prorating
rating74938703___rating
recrating121318793recrating
regrading121210203regrading
regrafting1545993regrafting
regranting1238323regranting
righting132610853rig_hting
serrating10513203serrating
sighting133110863sig_hting
signaling1136563signaling
signeting1136223signeting
sinuating1039683sinuating
situating1038883situating
uncrating12813183uncrating
upgrading1444903upgrading
uprating11311113_uprating
violating1337433violating
vitiating1338403vitiating

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411606.92321470.6
3Display Results1601600.0602666.7
 (SQL Overall)1786911607.40624127.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.