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

79 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
cepheid154543(None) 
cepheids1644241cepheids
aphid115515393_aph_id
behead1239923be_head
beheld1236413be_held
cached145419203cache_d
caped104931803cap_e_d
capped134721853cappe_d
capsid11312413cap_sid
cashed125124353cashe_d
cathead1338753cathead
ceased94920783cease_d
cebid104314073ce__bid
ceboid11310653ce_boid
ceded96118563ce_de_d
ceiled94114953ceile_d
celled94420323celle_d
censed94016323cense_d
cepe84926653cep_e__
cepes94424463cep_e_s
cephalad1643843cephalad
cephalic1777903cephalic
cephalin1577983cephalin
cered85227443ce_re_d
cervid1239323ce_rvid
cessed94615613cesse_d
cestoid104011673cestoid
chid106626403c__h_id
cichlid1545313cichlid
cipher133710263ciphe_r
ciphered1637053ciphered
ciphers14379993ciphers
cleped115114113clep_e_d
clupeid1234633clupeid
cohead123811123c_ohead
coheir1137583c_oheir
coped105036843cop_e_d
copied114618563copie_d
copped135221253coppe_d
coshed124217543coshe_d
cowherd1636953cowherd
creped114115703crep_e_d
cupid103212783cup__id
cupped134413983cuppe_d
cypher16306593cyphe_r
cyphered1934653cyphered
cyphers17316753cyphers
depend103510923dep_end
eched116919223_eche_d
ephebe1336063_ephebe
ephebi1345083_ephebi
ephebic1646513_ephebic
ephod1139123_eph_od
hophead16337923hophead
kepped15309543keppe_d
leched123716003leche_d
leporid1048153leporid
meshed124415933meshe_d
nephew1434113nephe_w
nephews1533323nephews
nephric1446213nephric
nereid7312923ne_reid
peched144915343peche_d
pepped103113403peppe_d
peptid112712373pep_tid
redhead1257053redhead
repaid94716323rep_aid
replead10399013replead
repled93319783reple_d
replied103914453replied
repped114616723reppe_d
saphead1357773saphead
scaphoid1646053scaphoid
shepherd1744373shepherd
teched124014433teche_d
tepid8314313tep__id
typhoid1648133typhoid
upheld12115563_upheld
xiphoid2045923xiphoid

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.406440125.6
2DLD Change Limit134027797.53017799.1
3Display Results79790.0332393.9
 (SQL Overall)178691797.96922423.3
 
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.