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

87 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
emigrate114960(None) 
emigrated1347071emigrated
emigrates1248581emigrates
emirate91015831emi_rate
migrate101314171_migrate
remigrate1249221remigrate
amirate91115952ami_rate
denigrate1168692denigrate
emeerate10410102emeerate
emigrant1148562emigrant
emigrants1244732emigrants
emigre937052emigr__e
emirates101214852emi_rates
immigrate1444352immigrate
migrated121110512_migrated
migrates111112852_migrates
misrate91319142_misrate
remigrated1447492remigrated
remigrates1348582remigrates
acierate10311813acierate
ameerate1039633ameerate
amirates101114793ami_rates
cirrate92413493_cirrate
citrate92216803_citrate
denigrated1366973denigrated
denigrates1298113denigrates
denitrate10810533denitrate
designate1147113designate
disrate81418523_disrate
emaciate1248753emaciate
emanate9312473em_anate
embrace1388893em_brace
embrute1145703em_brute
emeerates1149373emeerates
emendate1146783emendate
emigrating1467503emigrating
emigration13228213emigration
emigres1037673emigr_es
emulate9314123em_ulate
engrave1137133e_ngrave
enigmata1143663enigmata
ephorate1359503ephorate
epigram1247473epigra_m
epigrams1346113epigrams
epigraph1645193epigraph
epilate9314283epi_late
ergate7315143e_rg_ate
etiolate849523etiolate
execrate1739653execrate
figurate1237193_figurate
frigate11311063frig_ate
fumigate1446153fumig_ate
geminate11411813gemi_nate
grate64932883___grate
imitate9310873imi_tate
immigrated1643313immigrated
immigrates1544023immigrates
ingrate8715123_ingrate
irate55627983__i_rate
levigate1246623levig_ate
levirate1147623levi_rate
librate93214233_librate
ligate72519253_lig_ate
magnate10512703_magnate
meliorate1179483meliorate
migraine1157863_migraine
migrant10314313_migrant
migrants1138183_migrants
migrator1147873_migrator
mirage92313653_mi_rage
misate81222693_mi_sate
misdate101413963_misdate
misgrade1247503_misgrade
mismate111415353_mismate
misrated111315383_misrated
misrates101318243_misrates
nitrate72017013_nitrate
picrate112014143_picrate
pirate82322883_pi_rate
priorate10411733priorate
regrate82618663_regrate
revibrate1446383revibrate
sigmate10710143_sigmate
temperate1348513temperate
titrate72215573_titrate
vibrate122811523_vibrate
virgate1138733_virgate

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.423422437.4
2DLD Change Limit146162877.12320519.7
3Display Results87870.0332636.4
 (SQL Overall)178691877.57923577.1
 
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.