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 “emigrated” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 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
emigrated134707(None) 
emigrate1149601emigrate_
emigrates1248581emigrates
migrated121110511_migrated
remigrated1447491remigrated
denigrated1366972denigrated
emirate91015832emi_rate_
emirates101214852emi_rates
immigrated1643312immigrated
migrate101314172_migrate_
migrates111112852_migrates
misrated111315382_misrated
remigrate1249222remigrate_
remigrates1348582remigrates
acierated1238283acierated
amirate91115953ami_rate_
amirates101114793ami_rates
citrated112712253_citrated
denigrate1168693denigrate_
denigrates1298113denigrates
denitrated1298033denitrated
designated1345933designated
disrated10915573_disrated
emaciated1446933emaciated
emanated1139163em_anated
embraced15106673em_braced
embruted1344353em_bruted
emeerate10410103emeerate_
emeerates1149373emeerates
emendated1344653emendated
emigrant1148553emigra_nt
emigrants1244733emigrants
emigrating1467503emigrating
emigration13228213emigration
emigre937053emigr__e_
emigres1037673emigr__es
emitted103010853emi__tted
emulated11310793em_ulated
engrafted1443733e_ngrafted
engraved1335813e_ngraved
epilated11310753epi_lated
etiolated1047073etiolated
execrated1938353execrated
fumigated1644723fumig_ated
geminated1338543gemi_nated
grated84523923___grated
imitated1138263imi_tated
immigrate1444353immigrate_
immigrates1544023immigrates
levigated1445643levig_ated
librated113110313_librated
ligated92414143_lig_ated
meliorated1377003meliorated
migrator1147873_migrator
misdated121211123_misdated
misgraded1446233_misgraded
misgrafted1743793_misgrafted
mismated131111333_mismated
misrate91319143_misrate_
misrates101318243_misrates
nitrated92213153_nitrated
picrated132110113_picrated
pirated102515613_pi_rated
regrated102816333_regrated
revibrated1645443revibrated
titrated92611683_titrated
vibrated14228393_vibrated

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 Filter1786911486410.420425454.8
2DLD Change Limit148641677.87618872.7
3Display Results67670.0302233.3
 (SQL Overall)178691678.32621461.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.