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

179 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
coalify153668(None) 
calcify1735872c_alcify
calif104929102c_alif_
califs114915892c_alifs
clarify1536092clarify
coalier93416182coalier
coaling103722822coaling
coaly105521592coal__y
codify1537162co_dify
cornify1536252cornify
jollify2044262jollify
mollify1555502mollify
qualify2235472qualify
salify12311372_salify
alif76242143__alif_
alifs86121263__alifs
alkalify1842823alkalify
amplify1744083amplify
anality10313633anality
basify1437513_basify
beatify1536593beatify
boatlift1344683boatlift
cagily12411563c_agily
calf96339563c_al_f_
calfs104919383c_al_fs
calico103414433c_alico
caliph13311403c_aliph
calix145317353c_ali_x
calmly1337613c_almly
calory11312843c_alory
carnify1555883carnify
casefy1436273c_asefy
cavity14310013c_avity
certify1546243certify
chaffy20456473cha_ffy
chalice14311043chalice
chalky18468773chal_ky
chally144314293chal_ly
charily15310283charily
charity15311023charity
citify1437443c_itify
clarity12310913clarity
classify1644693classify
cliff135917133c__liff
cliffy17435243c__liffy
clift106422193c__lift
coal66939253coal___
coala77521123coal__a
coalas87418963coal_as
coalbin1137533coalbin
coalbins1237083coalbins
coalbox1844113coalbox
coaled95022713coal_ed
coaler84121713coal_er
coalers94419353coalers
coalfish1635493coalfish
coaliest10316223coaliest
coalified1546813coalified
coalifies1439113coalifies
coalifying1945033coalifying
coalpit1148513coalpit
coalpits1245403coalpits
coals76129603coal__s
coaming123818323coaming
coati75624643coati__
coating103525313coating
coatis85122603coati_s
coaxial16157003coaxial
coaxing173511703coaxing
cockily1838493cockily
codlin94516443codli_n
codling114418953codling
codlins104116243codlins
coeliac1138233coeliac
coevality1745383coevality
coif96337913co__if_
coifs105718703co__ifs
coiling103723453coiling
colby124415063co_l_by
coldly12459953co_ldly
colic95726173co_li_c
colicky1835783co_licky
colics104219903co_lics
colies84837053co_lies
colin76231693co_li_n
colins85229043co_lins
collide103214793collide
collie83621993colli_e
collied103316673collied
collier93618153collier
colliery13307363colliery
collies94326583collies
collins93419833collins
colly104926773co_l_ly
colony115417273co_lony
coly96940533co_l__y
comelily1546693comelily
comfy153710213co__mfy
comity13312713co_mity
coolie83821603cooli_e
coolies93824963coolies
cooling103422573cooling
coolish12312523coolish
coolly114811393cool_ly
cooly105525423cool__y
copurify1843053copurify
cornily12410853cornily
cosily113613853co_sily
coulis84018763couli_s
cowlick1835263cowlick
cowling134017423cowling
coxalgy2042603coxal_gy
coyly135614893coyl__y
cozily20349703co_zily
crazily2136923crazily
croakily1744733croakily
crucify1744063crucify
curlily1238383curlily
duality1147963duality
falsify1643613_falsify
foaling113515843foaling
foamily1546543foamily
fortify1636523fortify
gasify1336333_gasify
goalie7413163goali_e
goalies8316023goalies
goaling93515333goaling
godlily1235343godlily
gratify1436113gratify
hoarily1338973hoarily
holily123612953ho_lily
horrify1635023horrify
jellify2054543jellify
jollily1745773jollily
jollity1746143jollity
kalif125021363_kalif_
kalifs134410983_kalifs
khalif1657833khalif_
khalifa1742883khalifa
khalifs1754073khalifs
locality13148433locality
lowlife1335143lowlife
lowlily1335353lowlily
modality14117653modality
modify1537173mo_dify
molality13118363molality
morality131110333morality
mortify1536223mortify
nazify2134233_nazify
nodality12127423nodality
nonlife1038553nonlife
notify1236943no_tify
nullify1334713nullify
oilily93111723_oilily
opacify1743653opacify
orality101111683orality
ossify1244973_ossify
ovality1377593ovality
pacify1667473_pacify
policy133211513po_licy
polity113015863po_lity
quality1938563quality
ramify14268753_ramify
rarify123210063_rarify
ratify122610043_ratify
reality10313573reality
salsify1334703_salsify
scarify1537443scarify
scorify1535203sco_rify
sealift10312793sealift
soapily1237963soapily
sodality12127323sodality
tonality1139793tonality
torrify1335013torrify
totality1139373totality
uglify1333913_uglify
vilify1536773_vilify
vocality16137933vocality
zombify2642253zombify

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.393454684.5
2DLD Change Limit1340271796.90319415.8
3Display Results1791790.0632841.3
 (SQL Overall)1786911797.35924282.0
 
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.