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

82 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
exclave194519(None) 
enclave1257531enclave
exclaves2044921exclaves
clave105420152__clave
enclaved1456342enclaved
enclaves1357702enclaves
enslave1036272enslave
euclase938932euclase
exclaim1844942exclaim
exclude1744452exclude
calve105919923__calve
cave95941263__c_ave
clade85821013__clade
claver113816973__claver
claves115020063__claves
clavi104912923__clavi
cleave114212513__cleave
clove105619443__clove
conclave1556403conclave
crave105626313__crave
cyclase1436613cyclase
declare10411223declare
eave75733583e___ave
eclair836813e_clair
eclat7523603e_cla_t
eclats8313033e_clats
elate55335883e__late
emblaze2045773emblaze
emplace1338263emplace
emplane11410013emplane
emulate9314123emulate
encage93713503enc_age
encase83714363enc_ase
enchase1239453enchase
enclasp1145843enclasp
enclose999993enclose
enflame1236573enflame
engrave1137133engrave
enlace82213233e_nlace
enolase7310193enolase
enplane939723enplane
enslaved1245063enslaved
enslaver1144713enslaver
enslaves1136393enslaves
epilate9314283epilate
escalade1144383escalade
escalate1039323escalate
escape103811663esc_ape
escuage1035113escuage
euclases1039223euclases
evolve12306503evol_ve
excavate2045053excavate
exchange21124323exchange
excide1638423exc_ide
exciple1874683exciple
excise1538553exc_ise
excite15310883exc_ite
exclaimed2142843exclaimed
exclaimer2042843exclaimer
exclaims1943943exclaims
excluded1943433excluded
excluder1843453excluder
excludes1844383excludes
exclusive2144423exclusive
excrete1667163excrete
exculpate2044833exculpate
excuse1537423exc_use
execrate1739643execrate
exhale1636873ex_hale
exilable1737203exilable
exile126117653exil__e
expiate16910593expiate
explain1667043explain
explant16310133explant
explode1745963explode
explore1646613explore
exudate1537093exudate
lave75642143___lave
octave11157343_octave
oxalate1457623oxalate
reclame11411063reclame
slave84224033__slave

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 Limit134027827.53317792.0
3Display Results82820.0302733.3
 (SQL Overall)178691827.71923149.5
 
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.