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

101 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
callipee123773(None) 
calipee11412911ca_lipee
callipees1345301callipees
calliper1247511calliper
calipees1247412ca_lipees
caliper11410962ca_liper
callee84327292call__ee
calliope1256222calliope
calliopes1346142calliopes
callipered1542862callipered
callipers1356492callipers
aliped95414283_a_liped
allee54932123_all__ee
allied74217153_alli_ed
allies63827673_alli_es
ballies93725743balli_es
calcine11315273calci_ne
calcined1338743calcined
calcines12314753calcines
calcite11413783calci_te
calcites12313003calcites
calflike1735153calfli_ke
caliber1139733ca_liber
calibre1136603ca_libre
calices114321693ca_lices
caliche14329963ca_liche
calicle113111433ca_licle
calipered1454873ca_lipered
calipers1249443ca_lipers
caliph13311403ca_lip_h
caliphs1436753ca_liphs
callable12310753callable
called94126733call__ed
callees94117783call_ees
caller85125483call__er
callet84536763call__et
calling103826773calli_ng
callings113613833callings
callose9313663call_ose
calloses10313393calloses
callower13159073callower
callused1135853callused
calluses1039323calluses
carline93923623carli_ne
carlines103521673carlines
catlike132712933catli_ke
caulicle1245043caulicle
cauline92215603cauli_ne
challie124012853challi__e
challies133915643challi_es
challises14358783challises
cheliped1635043cheliped
collapse1244273collapse
collide103214793colli_de
collided12309803collided
collider113410423collider
collides113214473collides
collie83621993colli__e
collied103316683colli_ed
collier93618153colli_er
collies94326583colli_es
cullied104012353culli_ed
cullies94419963culli_es
cullises103111313cullises
dallied93713613dalli_ed
dallier84215373dalli_er
dallies84023193dalli_es
ellipse944013_ellipse
fallible1355363fallible
filliped1435223filliped
galilee8312213ga_lilee
gallied94115003galli_ed
gallies84122713galli_es
gallipot1145943gallipot
galloped12107153galloped
galloper11137193galloper
mallee84525593mall__ee
milliped1337383milliped
millipede1444223millipede
palliate10311893palliate
pallier94417163palli_er
rallied83514083ralli_ed
rallier73816273ralli_er
rallies73823343ralli_es
ralline73518413ralli_ne
sallied83316953salli_ed
sallier73320423salli_er
sallies73227813salli_es
scalloped1444463scalloped
scalloper1344453scalloper
taliped1078203ta_liped
talipes9611603ta_lipes
tallied83314753talli_ed
tallier72817213talli_er
tallies73624603talli_es
tallises82713263tallises
tullibee1044333tullibee
wallie93216803walli__e
wallies103320743walli_es
walloped14146833walloped
walloper13147113walloper

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 Limit1461621016.86021306.4
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.32924381.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.