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

80 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
emigrates124858(None) 
emigrate1149601emigrate_
emigrated1347071emigrated
emirates101214851emi_rates
migrates111112851_migrates
remigrates1348581remigrates
amirates101114792ami_rates
denigrates1298112denigrates
emeerates1149372emeerates
emigrants1244732emigrants
emigres1037672emigr__es
emirate91015832emi_rate_
immigrates1544022immigrates
migrate101314172_migrate_
migrated121110512_migrated
misrates101318242_misrates
remigrate1249222remigrate_
remigrated1447492remigrated
acierates11310813acierates
ameerates1149063ameerates
amirate91115953ami_rate_
citrates102315093_citrates
denigrate1168693denigrate_
denigrated1366973denigrated
denitrates1169513denitrates
designates1246363designates
disrates91118153_disrates
emaciates1347883emaciates
emanates10311333em_anates
embraces14128873em_braces
embrutes1245193em_brutes
emeerate10410103emeerate_
emendates1246083emendates
emigrant1148563emigra_nt
emigrating1467503emigrating
emigration13228213emigration
emigrations14187153emigrations
emigre937053emigr__e_
emulates10312573em_ulates
engraves1237233e_ngraves
ephorates1459163ephorates
epigrams1346113epigra_ms
epigraphs1745043epigraphs
epilates10313503epi_lates
ergates8314493e_rg_ates
etiolates949213etiolates
execrates1839563execrates
frigates12310933frig_ates
fumigates1545573fumig_ates
geminates12310043gemi_nates
grates75429893___grates
imitates10310503imi_tates
immigrate1444353immigrate_
immigrated1643313immigrated
ingrates9514173_ingrates
levigates1346493levig_ates
levirates1247493levi_rates
librates103412953_librates
ligates82318383_lig_ates
magnates11511613_magnates
meliorates1288903meliorates
migraines1286933_migraines
migrants1138183_migrants
migrator1147873_migrator
migrators1247543_migrators
mirages102213533_mi_rages
misdates111113633_misdates
misgrades1347363_misgrades
mismates121114563_mismates
misrate91319143_misrate_
misrated111315383_misrated
nitrates82516223_nitrates
picrates122013213_picrates
pirates93020333_pi_rates
priorates11410763priorates
regrates92618403_regrates
revibrates1546273revibrates
titrates82314663_titrates
vibrates132210613_vibrates
virgates1237923_virgates

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.420425454.8
2DLD Change Limit148641806.67322275.0
3Display Results80800.0302666.7
 (SQL Overall)178691807.12325086.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.