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

94 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
emersion104773(None) 
emersions1147281emersions
eversion1138711eversion
aversion1147312aversion
emission1047672emission
emulsion1045922emulsion
eversions1238362eversions
exertion15310082exertion
immersion1344282immersion
reversion1248092reversion
version10310922_version
aspersion1146163aspersion
aversions1247053aversions
cession939813_cession
coercion1246573coercion
demission1246033demission
derision939073_derision
desertion10410203desertion
dimension1244743dimension
diversion1346453diversion
eclosion1046893eclosion
effusion1444603effusion
egestion946863egestion
egression1046193egression
ejection172510043ejection
election102015353election
elision72311103e_lision
elusion72310953e_lusion
embryon1474063embr_yon
emerging1237893emerging
emeries91620023emer_ies
emerita938713emer_ita
emeriti949433emer_iti
emerod9139213emer__od
emeroid101511183emeroi_d
emeroids11147723emeroids
emersed10138513emers_ed
emesis84712623eme_si_s
emetin8613463eme_ti_n
emissions1146923emissions
emotion9711303em_otion
empoison1243843empoison
emulsions1145343emulsions
envision1145953envision
erasion7311963e_rasion
erection102115513erection
erepsin937383erepsi_n
erosion7311113e_rosion
etesian757853ete_sian
evasion1036753e_vasion
evection131910833evection
evulsion1155063evulsion
excision1746273excision
excursion1844613excursion
exertions1639763exertions
exsertion1646853exsertion
extension1646293extension
extrusion1645253extrusion
fermion1236763_fermion
immersions1444003immersions
imprison1244793imprison
inversion1247213inversion
lesion64715063_le_sion
mansion9611543_mansion
mention9314373_mention
merino8315093_mer_ino
merlin83916683_merli_n
merlon83012353_mer_lon
mesian84315503_me_sian
meson74118313_me_s_on
mission9312743_mission
morion86217733_mor_ion
morrion959003_morrion
obversion1444733obversion
omission1046533omission
oversoon1138303oversoon
pension9412203_pension
pereion9312053_pereion
person83517873_pers_on
perversion1545853perversion
recension1148863recension
recession1149103recession
recursion1146153recursion
remission1147333remission
retorsion946503retorsion
reversions1347573reversions
secession1146703secession
session739763_session
submersion1444343submersion
tension7311803_tension
ternion739493_ternion
thermion1345933thermion
torsion7310803_torsion
versions11310353_versions

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.406440125.6
2DLD Change Limit146162946.56322270.6
3Display Results94940.0303133.3
 (SQL Overall)178691946.99925530.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.