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

242 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
emigres103767(None) 
emigre937051emigre_
bemires113212832bemi_res
eagres74014572e_agres
emerges101310882emerges
emigrates1248562emigrates
emirs76116162emi_r_s
empires1139852empires
mires75640882_mi_res
mitres83922072_mitres
remiges103015472remig_es
admires1038663admi_res
aigret73720023_aigret
aigrets82810533_aigrets
amices105018013ami_ces
amides95722663ami_des
amies76837693ami__es
amigas95912163amig_as
amigos94511203amig_os
amines84727983ami_nes
amirs75924923ami_r_s
amities9317383amities
amperes11313983amperes
armigers1135703armigers
beiges91014403beig_es
beignes10149243beignes
bemingles1444743bemingles
bemire103312803bemi_re_
bemired123410633bemi_red
bemixes18338653bemi_xes
chigoes1338353chigoes
chirres123812253chirres
cires74932913_ci_res
coignes103912153coignes
deciares11510633deciares
demerges12129503demerges
demies94825803demi__es
demigods1343983demigods
demirep1236213demi_rep
demireps1343993demi_reps
demises103719563demi_ses
demiurges1343863demiurges
desires81316133desi_res
digress938323_digress
dirges84915103_dirges
eagers74523683e_agers
eagles73819163e_agles
eagre64315323e_agre_
edgers84413913e_dgers
edges75718723e_dg_es
edibles1048003edibles
edifies113012283edifies
ediles74016983edi_les
editress944933editress
effigies1543513effigies
egers65120373e__gers
eggers84612583e_ggers
egises7312493egi_ses
egress73310433e__gress
egret63327313e__gret
egrets72712243e__grets
eiders74321363e_iders
eights103618983e_ights
elegies81312903elegies
elides74420693eli_des
elites66027123eli_tes
embarks15337353embarks
embars103812883embar_s
embers104116183ember_s
embrues1136473embrues
emcees1037813em_cees
emeers83314183emeer_s
emerge91510463emerge_
emerged11158213emerged
emeries91620023emeries
emes65434663em___es
emeses86114963em_eses
emeutes938013emeutes
emigrant1148553emigrant
emigrants1244733emigrants
emigrate1149603emigrate
emigrated1347063emigrated
emir65918703emi_r__
emirates101214843emirates
emits75421473emi__ts
emitted103010853emitted
emitter93211083emitter
emitters10349643emitters
emmers104013223emmer_s
emoters94712873emoters
emotes84620283em_otes
empales112411433empales
emperies12314563emperies
empire1039323empire_
empress1138163em_press
empties11712243empties
emydes1236173em_ydes
encores9315213encores
endures83314603endures
engines81114463engines
engirds995053engirds
enigmas1045163enigmas
enisles72312603enisles
enmities10611353enmities
ensures73315903ensures
entires71517783entires
enures63919713e_nures
epicures1246513epicures
epigones1138023epigones
epigons1048183epigons
epigram1247473epigram
epigrams1346113epigrams
epimeres12117653epimeres
epimers11109493epimers
eringoes937433eringoes
ermines9416663ermi_nes
etageres936863etageres
euchres1288663euchres
evinces1237803evinces
evites94916473evi_tes
exilers14419733exilers
exiles134816403exi_les
exines135715803exi_nes
expires1638683expires
eyres84921773e__yres
fibres114312123_fibres
figures11239103_figures
fires85740753_fi_res
friges104116483frig_es
gigues8128993_gigues
goitres8389563goitres
grigris934093grigris
hires86134343_hi_res
imagers10107753imagers
images91411463imag_es
imagoes10126403imagoes
imides94515343imi_des
imines84918353imi_nes
immures1136713immures
ires45639283__i_res
lemures938793lem_ures
ligers75022033_ligers
ligures8269883_ligures
litres65220393_litres
livres94311863_livres
madres93718183_madres
mages85036023_mag_es
maigre9309163maigre_
mares76457633_m_ares
marges94525713_marges
matres84522233_matres
meagre9349323meagre_
meinies92516073meinies
meioses9310833meioses
meres75143573_m_eres
mergees104411233mergees
mergers103813423mergers
merges94122483merg_es
metres85121563_metres
miches134320733_miches
micros104115363_micros
midges103516473_midges
miggles113512033_miggles
miggs96311373_mig_gs
mights123516253_mights
migrates111112843_migrates
migs76935323_mig__s
mikes115129893_mi_kes
milers84625163_milers
miles74645073_mi_les
milles84526563_milles
milreis937323_milreis
mimers105520183_mimers
mimes95732023_mi_mes
minces104420803_minces
miners84126633_miners
mines75651953_mi_nes
mingles103719003_mingles
minkes124618783_minkes
minxes154612983_minxes
mioses84318853_mioses
mire66748233_mi_re_
mired85729223_mi_red
mirex146816623_mi_rex
mirks115122143_mi_rks
mirs66940573_mi_r_s
misers85025703_misers
mises74740563_mi_ses
misgrew1335523_misgrew
misses85130873_misses
miters84328773_miters
mites75141803_mi_tes
mitre75522423_mitre_
mitred94414343_mitred
mixers154513563_mixers
mixes147224403_mi_xes
moires8915633_moires
mores76249643_m_ores
mures75937213_m_ures
murres85019043_murres
nitres65519333_nitres
ogres65818633__ogres
ombres103911143om_bres
pedigree1244883pedigree
pedigrees1343373pedigrees
perigees1189493perigees
premieres13288233premieres
quires154015733qui_res
redigress1143643redigress
refigures1344543refigures
refires104820313refi_res
rehires105016113rehi_res
remerges111110203remerges
remigrates1348563remigrates
remises93423483remi_ses
remixes164313873remi_xes
retires74726213reti_res
rewires104717113rewi_res
semioses10611013semioses
semipros1244483semipros
semises93916553semi_ses
shires95225573shi_res
sires55945373_si_res
smidges11448193smidges
smilers94113843smilers
smiles84522293smi_les
smirks124910123smi_rks
smiters93414363smiters
smites83921923smi_tes
spires84628113spi_res
tigers75616503_tigers
tigress836093_tigress
timbres11249343timbres
tires55437493_ti_res
titres64718933_titres
umpires1137813umpires
unmitres1036863unmitres
veligers1237023veligers
venires103012453veni_res
vires84529683_vi_res
wires86034913_wi_res
zaires1539703zai_res

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272427.04619021.7
3Display Results2422420.0763184.2
 (SQL Overall)1786912427.27824552.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.