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

107 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
cellmate123787(None) 
cellmates1347511cellmates
celibate1259312celibate
cellae84915932cell_a_e
celomata1296632celomata
climate11312832c_limate
coelomate1398112coelomate
collate92919682coll_ate
collimate1348172collimate
fellate10313432fell_ate
helpmate1545602helpmate
ocellate1037872ocell_ate
acclimate1546233acclimate
acoelomate1454363acoelomate
bedmate1239433be_dmate
bellman1137183bellma_n
bullate93415073bull_ate
calamata1247553calamata
calamite12312533calamite
calceate1239863calceate
califate13310483califate
calycate1537893calycate
casemate1239843casemate
celebrate1348083celebrate
celeste949653ce_leste
celibates1358633celibates
cella75420313cell_a__
cellar84514983cell_a_r
cellarage1243563cellarage
cellared11398793cell_ared
cellarer10317923cell_arer
cellaret103713573cell_aret
cellars93713693cell_ars
cellist9314423cellist_
cellists1038563cellists
cellulase1143873cellulase
cellule936523cell_ule
cellulite11114873cellulite
cerate84829463ce__rate
checkmate2243533checkmate
chelate122914893chel_ate
chlorate133112693chlorate
cholate122114933chol_ate
chromate15312783chromate
ciliate9514603c_iliate
clavate1238713c_lavate
climates12311973c_limates
coelomata1385333coelomata
coelomates1497573coelomates
coinmate1239063coinmate
collage102813763coll_age
collated113615063coll_ated
collates103019143coll_ates
colligate1248293colligate
collimated1556083collimated
collimates1447973collimates
collocate1348673collocate
colocate12313443colocate
comate104124843c__omate
copemate1439993copemate
cremate113816183c_remate
crewmate15405633crewmate
cultrate10310873cultrate
cyclamate1843793cyclamate
dealate83617843deal_ate
decimate13411123decimate
deflate113613943defl_ate
delate73827753de_l_ate
delegate10410463delegate
delicate11315493delicate
elate55335883_e_l_ate
elevate101110373_elevate
eluate62315433_e_luate
fellated1239563fell_ated
fellates11312753fell_ates
fermate122813003fe_rmate
gallate83417133gall_ate
gelate73421263ge_l_ate
gemmate12418383ge_mmate
hellcat12410173hellcat_
hellcats1346323hellcats
hellkite1544933hellkite
helpmates1645513helpmates
messmate1246393messmate
ocellated1245453ocell_ated
palliate10311893palliate
palmate113215233_palmate
peltate92013773pe_ltate
plumate1149803_plumate
reflate103516263refl_ate
relate64033633re_l_ate
relegate9311243relegate
relocate10713533relocate
remate84428683re__mate
replate93420053repl_ate
reslate73520593resl_ate
seatmate1048573seatmate
selenate81712533selenate
soulmate1047193soulmate
stellate8310503stell_ate
teammate1245613teammate
telltale844423telltale
tollgate946253tollgate
vallate103016563vall_ate
velate93720143ve_l_ate
vellicate1446433vellicate
wellsite1145133wellsite

Search took 9 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.500357382.0
2DLD Change Limit1461621077.51619446.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911078.06222164.6
 
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.