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

135 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
certify154624(None) 
acetify1545002ace_tify
aerify122810112aer_ify
beatify1536592beatify
carnify1555882carnify
citify1437442c_itify
cornify1536252cornify
decertify1843462decertify
fortify1636522fortify
metrify1535622metrify
mortify1536222mortify
petrify1536572petrify
recertify1743642recertify
rectify1536452rectify
terrify1336352terrify
testify13246942testify
verbify1834992verbify
verify153110162ver_ify
versify1636332versify
acerbity1544273acerbity
aerily93017013aer_ily
artily92814713_artily
beautify1643183beautify
brutify1543883brutify
caitiff1547133caitiff
calcify1735873calcify
carting104228283carting
cattily123210853cattily
cecity1398153ce_city
centile94217183centile
centime114513033centime
centimo11609543centimo
century1237193century
ceratin93020163cerati_n
ceratins102818733ceratins
cerci93716393cerci__
cercis104614493cerci_s
ceria75125353cer_i_a
cerias83321983cer_ias
ceric94023093cer_i_c
cering94522533cer_ing
ceriph1398463cer_iph
cerise84822043cer_ise
cerite84724873cer_ite
cerites94823433cerites
cerium10313763cer_ium
cerotic11415063ceroti_c
certain92612213certain
certainly1443153certainly
certainty1443193certainty
certes84623083cert_es
certified1548413certified
certifier1447353certifier
certifies14310323certifies
certifying1945313certifying
cervid1239323cervi_d
cervine122610803cervine
cervix1865163cervi_x
cesti75217423cesti__
chertier1387873chertier
cherty144612473chert__y
chestily1645523chestily
clarify1536093clarify
clerisy1246823cler_isy
coalify1536683coalify
codify1537163c_odify
cornily12410853cornily
cortin82423153corti_n
cortina91915973cortina
cortins92421333cortins
cretic102816283creti_c
cretics112911653cretics
cretin82917913creti_n
cretins93216423cretins
crucify1744063crucify
curlily1238383curlily
curtesy1265833curtesy
curtly1149283curt_ly
curtsey1255013curtsey
curtsy1156643curt_sy
deify124112763de__ify
densify1435293densify
desertify1643643desertify
destiny113111463destiny
dirtily1138583dirtily
edify12308563_e_dify
eerily92913563eer_ily
entity9312053_entity
ferity122813343fer_ity
fertile10311733fertile
gentrify1544683gentrify
gratify1436113gratify
heartily1436563heartily
heftily1635763heftily
horrify1635023horrify
identify1544133identify
jellify2054543jellify
jerkily2134623jerkily
justify2034663justify
meatily12311093meatily
merrily1238633merrily
mystify1843563mystify
nervily1336863nervily
nitrify1335793nitrify
notify1236943_notify
perfidy1635263perfidy
perkily1637803perkily
pertly115312543pert_ly
pettily1238173pettily
prettify1644343prettify
purify14399153pur_ify
rarify123210063rar_ify
ratify122610043_ratify
reedify1465763reedify
refortify1842833refortify
reify114814973__reify
renotify1454833renotify
reunify1344453reunify
scarify1537443scar_ify
scorify1535203scor_ify
serif84132133ser_if_
serifs94017053ser_ifs
serotiny1148573serotiny
stratify1445703stratify
tartily103511573tartily
tertial7313863tertial
tertian7511193tertian
tertiary1145433tertiary
testily102910803testily
torrify1335013torrify
verily122616053ver_ily
verity123714853ver_ity
vertigo1146133vertigo
vitrify1645003vitrify
zestily19167563zestily

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 Limit1340271356.81319672.2
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.01525472.7
 
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.