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

222 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
citify143744(None) 
acetify1545002acetify
acidify1645242acidify
caitiff1547132caitiff
certify1546242certify
citied94014142citied
cities84524852cities
citing94220182citing
city95122622cit__y
codify1537162codify
lithify1644762lithify
minify1439252minify
nidify1336762nidify
nitrify1335792nitrify
notify1236942notify
ratify122610042ratify
vilify1536772vilify
vinify1536922vinify
vitrify1645002vitrify
vivify1834702vivify
acidity1338593acidity
aerify122810113aerify
airily93014823airily
artily92814713artily
basify1437513basify
beatify1536593beatify
biffy164711133bi_ffy
bitchy16479203bitchy
biting95321823biting
bitsy104511303bit_sy
bitty106119173bit_ty
brutify1543883brutify
cagily12411563cagily
caitiffs1642883caitiffs
calcify1735873calcify
calif104929103calif_
califs114915893califs
carnify1555883carnify
casefy1436273casefy
catchy16559583catchy
cation83925503cation
cattily123210853cattily
catty104520413cat_ty
cavity14310013cavity
cecity1398153cecity
chaffy20456473chaffy
chitin113114963chiti_n
chitins122713793chitins
chitty14329433chit_ty
chivy164810363c_hivy
chuffy20445863chuffy
cicely1338833cicely
cilia73016763cili_a
ciliary1247923ciliary
cilice103213353cilice
cilium104311373cilium
cissy104811073ci_ssy
cite65640343cit__e
cited84421953cit_ed
citer74827333cit_er
citers85022983citers
cites74435593cit_es
cither114616683cither
citified1438253citified
citifies13310683citifies
citifying1845383citifying
citizen1845713citizen
citola838393citola
citole8311503citole
citral81113893citral
citric102812313citric
citrin82615413citrin
citrine92514023citrine
citrins92614363citrins
citron83112983citron
citrus83610923citrus
citrusy12284183citrusy
civic123412543civi_c
civics13397823civics
civie103716353civi_e
civies114116443civies
civil103411933civi_l
civilly1535483civilly
civism1337243civism
civvy16435463ci_vvy
clarify1536093clarify
cliff135917133c_liff
cliffy17435243cliffy
clift106422193c_lift
clitic103315053cliti_c
clitics11279973clitics
coalify1536683coalify
coif96337913c_oif_
coifs105718703c_oifs
coition9314313coition
comfy153710213c_omfy
comity13312713comity
cornify1536253cornify
cosily113613853cosily
coting94629253coting
cozily20349703cozily
criminy14268453criminy
critic103616813criti_c
critics112811093critics
crucify1744063crucify
cuif96529143c_uif_
cuifs104814693c_uifs
cutely115312803cutely
cutesy114810733cutesy
cutey105819793cut_ey
cutie76925933cuti_e
cuties84927363cuties
cutin75022783cuti_n
cutins83919983cutins
cutis77723763cuti_s
cutoff1436563cutoff
cutty105417223cut_ty
deify124112763_deify
dignify1543893dignify
dimity12310473dimity
dirtily1138583dirtily
ditsy95612563dit_sy
ditty95019293dit_ty
ditzy186513283dit_zy
edify12308563_edify
entity9312053entity
fitchy17437623fitchy
fitly115114973fit_ly
fixity19427803fixity
fortify1636523fortify
gasify1336333gasify
gratify1436113gratify
icily101211693_icily
ickily1535753ickily
ictic9311803icti_c
iffy135312283_i_ffy
ignify1334513ignify
itchy13449013_itchy
jiffy21458313ji_ffy
jiminy1836273jiminy
jitney16304623jitney
justify2034663justify
kiting114117093kiting
kitty124614563kit_ty
lignify1443793lignify
liquify2244033liquify
litany939053litany
metrify1535623metrify
micrify1744693micrify
miffy163910203mi_ffy
mistily122612343mistily
mitier83620673mitier
mitis75425993miti_s
mity95528213mit__y
modify1537173modify
mortify1536223mortify
motif10519683motif_
motifs1139673motifs
mutiny113612683mutiny
mystify1843563mystify
nazify2134233nazify
niftily1335753niftily
nigrify1444133nigrify
nitery94412173nitery
nitid61817833niti_d
nitty85418313nit_ty
oilily93111723oilily
ossify1244973ossify
pacify1667473pacify
petrify1536573petrify
pitchy16479673pitchy
pithily1567033pithily
pithy135614463pit_hy
pitied94017253pitied
pitier84019823pitier
pities83828083pities
pitiful1245863pitiful
pity96031933pit__y
purify14399153purify
ramify14268753ramify
rarify123210063rarify
rectify1536453rectify
reify114814973_reify
ritzily1945143ritzily
ritzy175611163rit_zy
salify12311373salify
satiny93817983satiny
satisfy1344183satisfy
scarify1537443scarify
scorify1535203scorify
signify1444853signify
siting74126623siting
stiff114219243_stiff
stimy105114743_stimy
testify13246943testify
tidily102811393tidily
tidy86822423__tidy
tiff104727723__tiff
tinily94014433tinily
tiny76134633__tiny
titi47130623titi__
titian62512663titian
titis56023813titi_s
titty85316653tit_ty
tivy1014516863__tivy
typify1734523typify
uglify1333913uglify
unify113611113_unify
untidy1059153untidy
verify153110163verify
wilily123310763wilily
wirily123310783wirily
witchy17468593witchy
withy144813763wit_hy
witing103522823witing
witney12356843witney
wittily1336173wittily
witty114717013wit_ty
zincify2443913zincify
zinkify2643123zinkify
ziti136022373ziti__
zitis145815583ziti_s

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162225.92319030.2
3Display Results2222220.0762921.1
 (SQL Overall)1786912226.38927968.5
 
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.