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

309 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
cheapo13481008(None) 
cheap126915941cheap_
cheapos14418511cheapos
cheaps134613681cheaps
capo85829212c__apo
chao95727312ch_a_o
chap114928492ch_ap_
chape125221142ch_ape
chaps125326062ch_aps
chapt125827642ch_apt
cheapen14407622cheapen
cheaper144010582cheaper
cheapie1437562cheapie
cheaply1735022cheaply
cheat105732452chea_t
cheats114519542cheats
cheep125416502cheep_
cheeps135312912cheeps
cheero114712932cheero
chemo12313632che_mo
chiao105618362chia_o
heap96432892_heap_
heaps105223222_heaps
heapy135914982_heapy
ahead96817053ahea_d
apo511142123___apo
beano75421553_beano
cacao95420003caca_o
calo64936443c__alo
camo85731753c__amo
campo115219763c_ampo
canape10913513canape
cap76758983c__ap_
cape87242783c__ape
caph116623293c__aph
capon95221873c__apon
capos94826073c__apos
caps87147893c__aps
catalo8314853catalo
cease75227653c_ease
cello74919583c_ello
cento76625173c_ento
cep75736333c_e_p_
cepe84926653c_e_pe
ceps86125953c_e_ps
cero66329453c_e_ro
chad105525503ch_a_d
chador1238673ch_ador
chads116122233ch_ads
chaebol1444943chaebol
chaeta11310683chaeta
chafe135117353ch_afe
chaff165016283ch_aff
chai95929903ch_a_i
chain105723673ch_ain
chair105519633ch_air
chais107530313ch_ais
chalk144814603ch_alk
chalot113020133ch_alot
cham115532313ch_a_m
champ145017963ch_amp
champs154915683champs
champy18509613champy
chams126028503ch_ams
chang115418563ch_ang
chant105932693ch_ant
chaos105622863ch_aos
chapel134911373ch_apel
chapes135421873ch_apes
char95132153ch_a_r
chard116124743ch_ard
chare105231983ch_are
chark144222713ch_ark
charm126124663ch_arm
charpoy1735713charpoy
charr104821783ch_arr
charro114212953charro
chars105936643ch_ars
chart105038283ch_art
chary135023133ch_ary
chase105127123ch_ase
chasm125518793ch_asm
chat95546133ch_a_t
chats105730093ch_ats
chaw126224633ch_a_w
chaws135022463ch_aws
chay124924873ch_a_y
chays135319743ch_ays
cheapens15305943cheapens
cheapest1536073cheapest
cheapies1539033cheapies
cheapish1844333cheapish
cheated134416343cheated
cheater124816963cheater
chebec1536963chebec
chechako22132463chechako
check164714713che_ck
checks174912703checks
cheder125113493cheder
cheek145115713che_ek
cheeks154712783cheeks
cheeky18448613cheeky
cheeped153410593cheeped
cheeper143610743cheeper
cheer105420383che_er
cheerio12379313cheerio
cheeros123711633cheeros
cheers114518913cheers
cheery144913153cheery
cheese113812763cheese
cheesy14419193cheesy
chef125125623che__f
chefdom18134073chefdom
chefed155010563chefed
chefs136214663che_fs
chegoe1237273chegoe
chela103916803che_la
chelae113614603chelae
chelas113817203chelas
chelate122914893chelate
chelator1347913chelator
chemic153012093chemic
chemos13311723chemos
chenopod1643943chenopod
cheque2036663cheque
cheroot12413693cheroot
cherry144810763cherry
chert105232103che_rt
cherts115617233cherts
cherty144612473cherty
cherub1337263cherub
chess105016923che_ss
chest104926143che_st
chests114916263chests
chesty144610503chesty
chetah14399583chetah
chetahs15347073chetahs
cheth135013823che_th
cheths14389823cheths
cheviot1546933cheviot
chevre14318313chevre
chevron1575783chevron
chevy16479993che_vy
chew126622133che__w
chewed154415013chewed
chewer145512623chewer
chews135418513che_ws
chewy165011903che_wy
chez184519023che__z
chia96026623chia__
chias104625523chia_s
chiasm13449103chiasm
chiaus113611313chiaus
chicano1496873chicano
chico124218253ch_ico
chimp145216473chimp_
chimps155713663chimps
chino105823313ch_ino
chip116726423ch_ip_
chippy18437613chippy
chips125721253ch_ips
chiro105320343ch_iro
chirp124717163chirp_
chirps135414003chirps
chirpy16498913chirpy
choana1138443choana
cholo105217973ch_olo
chomp144815663chomp_
chomps155112223chomps
chop116024923ch_op_
choppy18376293choppy
chops125019873ch_ops
chromo132811013chromo
chump145315443chump_
chumps154313823chumps
chuppa1543973chuppa
churro11448353churro
ciao64924183c_ia_o
clap86429043c_lap_
claps95626183c_laps
clapt98027173c_lapt
claro75018693c_laro
clean75420413clea_n
cleans85817053cleans
clear76219053clea_r
clears84116563clears
cleat76335063clea_t
cleats84919313cleats
cleave114212513cleave
clepe94617383cle_pe
clept95725773cle_pt
coapt96131533c_oapt
coempt12311033coempt
cohead123811123cohea_d
coheads13289233coheads
compo115318573c_ompo
crap85731843c_rap_
crape96128443c_rape
craps95328643c_raps
creak115418433crea_k
creaks124315963creaks
creaky154911553creaky
cream95721353crea_m
creams104715253creams
creamy134811363creamy
crease85519573crease
creasy114612303creasy
create85126383create
creator93714443creator
credo84815573cre_do
creep95218103creep_
creeps104213623creeps
creepy13418803creepy
crepe95520723cre_pe
crepon1039943cre_pon
crept95125893cre_pt
crepy124812703cre_py
cyano105512493c_yano
expo1349183__expo
gherao1036753gherao
ghetto1036073ghetto
halo76437323_h_alo
hao67251123_h_a_o
hap87360053_h_ap_
haps96443463_h_aps
head87137173_hea_d
heads95127113_heads
heady125117263_heady
heal75645693_hea_l
heals85733453_heals
heaped124516903_heaped
heaper114119523_heaper
hear76143883_hea_r
heard95222753_heard
hears86737373_hears
heart85440743_heart
heat77061423_hea_t
heath115724283_heath
heats85838403_heats
heave114521813_heave
heavy144814183_heavy
helio85321193_helio
hello86522983_hello
helo75332853_he_lo
help95328923_help_
helps105219343_helps
hemp115725623_hemp_
hemps126917333_hemps
hempy154912763_hempy
hep86644143_he_p_
hero74635783_he_ro
hexapod2043653_hexapod
hippo12369063_hippo
hypo127516353_h_ypo
kakapo1143853kakapo
khaph17395963kh_aph
leap66032683_leap_
leaps75522933_leaps
leapt75027473_leapt
neap66927013_neap_
neaps75618323_neaps
pepo87622153_pe_po
reap65934743_reap_
reaps75626193_reaps
repo66027543_re_po
rhea75017433rhea__
rheas84816953rhea_s
scherzo2153943scherzo
schnaps1443703schnaps
shako125516093sh_ako
shape105125113sh_ape
shea76031573shea__
sheaf115424123shea_f
sheafs124912883sheafs
sheal84927703shea_l
sheals94420643sheals
shear85424833shea_r
shears93820903shears
sheas86331793shea_s
sheath12412893sheath
sheave124514003sheave
sheep105321523sheep_
sherpa1138093sherpa
shnaps1148083shnaps
sleazo15257523sleazo
sneap75514823sneap_
sneaps84510863sneaps
teapot8416763_teapot
teapoy1138113_teapoy
tempo95214973_tempo
therapy1536613therapy
thesp105410313thesp_
thesps11448263thesps
threap11569663threap_
threaps12488643threaps
upheap13105213upheap_
upheaps1494233upheaps
weapon11288113_weapon
whamo135511263wh_amo
whap125119643wh_ap_
whaps135115163wh_aps
wheal115716183whea_l
wheals124512523wheals
wheat114924573whea_t
wheats125013223wheats
wheep136214353wheep_
wheeps14439953wheeps
whelp136012093whelp_
whelps14437843whelps

Search took 6 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.376475242.0
2DLD Change Limit1127163094.73323814.9
3Display Results3093090.0933322.6
 (SQL Overall)1786913095.20234350.4
 
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.