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

380 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
choicer1419789(None) 
chicer134513601ch_icer
choice132010521choice_
choices142010611choices
chancer144215632chancer
chider125116052ch_ider
chimer135517202ch_imer
choicely1843822choicely
choicest15226452choicest
choir105313592choi__r
choired13349342choired
choker154314372cho_ker
chokier1638042chokier
choler113717152cho_ler
chomper163810072chomper
chooser124412962chooser
chopper163611892chopper
chouser125212942chouser
chowder16387802chowder
coiler84421592c_oiler
coiner84323782c_oiner
voicer113910542_voicer
achier113914263ach_i_er
avoider1155813avoider
boiler84319273_boiler
broider103912973broider
broiler92911753broiler
cagier93715933cagi_er
cahier113615773cahi_er
cakier123115243caki_er
caliber1139733caliber
calices114321693calices
caliper11410963caliper
cancer104220923c_ancer
carices114220953carices
caviler1249063caviler
ceiler84013963c_eiler
chafer144714573ch_afer
chaffer18389473chaffer
chaine115119223chaine_
chained133812693chained
chaines124518733chaines
chair105519633chai__r
chaired134211243chaired
chaise114916413chaise_
chaises124317493chaises
chalice14311043chalice_
chaliced1637043chaliced
chalices15310813chalices
chamber164011053chamber
chamfer17399853chamfer
champer163813403champer
chance134617093chance_
chanced154113213chanced
chancel144011773chancel
chancers154313483chancers
chancery18366653chancery
chances145218093chances
chancier1538823chancier
chancre14348783chancre
changer134215543changer
chanter123919733chanter
chapiter1536603chapiter
chapter144213853chapter
charger133914063charger
charier124317903charier
charmer144913663charmer
charter123918303charter
chaser114918383ch_aser
chaster124718503chaster
chatter124416643chatter
chaufer15347943chaufer
chawer144314413ch_awer
cheaper144010583cheaper
cheater124816953cheater
checker18329533checker
cheder125113493ch_eder
cheeper143610743cheeper
cheer105420383ch__eer
cheerer123511753cheerer
chelicera1642883chelicera
chequer2135153chequer
chewer145512613ch_ewer
chewier1537583chewier
chic115925203ch_ic__
chica125818263ch_ic_a
chicaner1586073ch_icaner
chicas135916463ch_icas
chicest14209943ch_icest
chichi1637093ch_ichi
chichier1836023ch_ichier
chick165419133ch_ic_k
chickee183111553ch_ickee
chicken18278983ch_icken
chicks175317593ch_icks
chicle134312543ch_icle
chicles143512503ch_icles
chicly16429203ch_icly
chico124218253ch_ic_o
chicory1735993ch_icory
chicos134614833ch_icos
chics123920943ch_ic_s
chide115321013ch_ide_
chided135113963ch_ided
chiders135312943ch_iders
chides124620473ch_ides
chief134419473ch_i_ef
chiefer1536863chiefer
chiel104918973ch_i_el
chigger1436003chigger
chile105626893ch_ile_
chiles115425303ch_iles
chiller124112183chiller
chimar133911463ch_imar
chime125322593ch_ime_
chimed145814833ch_imed
chimera14389263ch_imera
chimere144010633ch_imere
chimers144515133ch_imers
chimes134922573ch_imes
chine105231723ch_ine_
chined125620063ch_ined
chines115029173ch_ines
chipper163912583chipper
chirker16429323chirker
chirper14359963chirper
chirr105015903ch_i_rr
chirre114111853ch_irre
chisel112111943ch_isel
chitter124112963chitter
chive135117623ch_ive_
chives144317593ch_ives
chock164316613cho_c_k
chocked194411613chocked
chocks174815313cho_cks
choirs114911873choi_rs
choke145118023cho_ke_
choked164914793cho_ked
chokers164311513cho_kers
chokes154917383cho_kes
chokey184811713cho_key
cholera12409093cho_lera
cholers124215193cho_lers
choline122915383choline_
cholines132214483cholines
chomped17329773chomped
chompers17369573chompers
choose115116143choose_
choosers134810863choosers
chooses125717413chooses
choosey15459233choosey
choosier1337163choosier
chopine143512263chopine_
chopines152711733chopines
chopped174511003chopped
choppers174110453choppers
choppier17286643choppier
chorded144710553chorded
chore105126763cho_re_
chorea115216083cho_rea
chored125321883cho_red
chores114828023cho_res
choric133515893choric__
chorine123218363chorine_
chorines132917253chorines
chorister1487143chorister
chorten122811303chorten
chortler13336843chortler
chose105925403cho_se_
chosen116014133cho_sen
choses115825123cho_ses
chouse116017563chouse_
choused135012463choused
chousers134610183chousers
chouses125117813chouses
chowders17387533chowders
chowed154914643cho_wed
chowse144711753chowse_
chowsed16478603chowsed
chowses155611283chowses
chromier1538033chromier
chronicler1752873chronicler
chudder14245943chudder
chuffer18337143chuffer
chugger1445373chugger
chukker1543833chukker
chunter123911473chunter
churner12298343churner
cicero1048503c__icero
cider84723313c__ider
cilice103213353cilice_
cilices113814023cilices
cimices13279803cimices
citer74827323c__iter
claimer11279883claimer
clicker154111883c_licker
clobber13378163clobber
clocker153910873clocker
clogger11438803clogger
cloister1037093cloister
cloner84418093clo_ner
closer84918203clo_ser
clouter93511683clouter
clover114617123clo_ver
clowder13367933clowder
coacher143714113c_oacher
coaler84121703c_oaler
coater84329553c_oater
coaxer153912783c_oaxer
cobber124116843c_obber
cocker144320393c_ocker
codder104416333c_odder
coder86134213c_o_der
codger105814843c_odger
codices12512583codices
coercer1138383coercer
coffer144112863c_offer
coherer122912783coherer
coholder1436063coholder
coifed124113063c_oifed
coiled95123933c_oiled
coilers93619903c_oilers
coined94523603c_oined
coiners93620753c_oiners
coinfer12419393c_oinfer
cointer93616723c_ointer
coir66327243c_oi__r
colder95121833c_older
colter84625093c_olter
comber125118503c_omber
comer95832693c_o_mer
concern113011963c_oncern
concert113325223c_oncert
concur10411093c_oncur
confer114018683c_onfer
conger95024273c_onger
conifer123212643conifer
conker124721553c_onker
conner84423963c_onner
cooer74831013c_o_oer
cooker124722453c_ooker
cooler84824713c_ooler
cooper104221123c_ooper
cooter85128613c_ooter
coper95336093c_o_per
copier103722893c_opier
copper124321893c_opper
copter109822013c_opter
corder94322873c_order
corer75538873c_o_rer
corker124720853c_orker
corner84625623c_orner
cosher114819903c_osher
cosier84423753c_osier
coster84331293c_oster
cotter84926673c_otter
coucher144515853c_oucher
couter84930203c_outer
cover105430773c_o_ver
cower104531773c_o_wer
cowier113616163c_owier
coyer105222843c_o_yer
cozier173315143c_ozier
crier74724463c_ri_er
croaker133010683croaker
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropper133312963cropper
crosier94116573crosier
crosser95015463crosser
crowder13389843crowder
crower114117553cro_wer
crowner124012593crowner
crozer175112843cro_zer
crozier18369933crozier
cruiser93410433cruiser
culices113713123culices
cylices14359283cylices
deicer94114413_deicer
dicer85426423__dicer
echoer114011103echo__er
echoic1339043echoic__
eloiner7149183eloiner
enticer91510423enticer
forcer114917343_forcer
goiter74116203_goiter
gooier73516213gooi_er
grocer94212143gro_cer
hailer94720343_hailer
heifer1238203_heifer
hider95024083_h_ider
hiker125119393_h_iker
hirer85423123_h_irer
hoaxer16348563_hoaxer
hobber134114633_hobber
hocker155118563_hocker
hoer76533983_ho__er
hogger114615083_hogger
hoick145210683_hoic_k
hoicked1735963_hoicked
hoicks15378283_hoicks
hoiden103612333_hoiden
hoise85224773_hoise_
hoised105117433_hoised
hoises94823673_hoises
hoister103714203_hoister
hokier134214033_hokier
holder104619653_holder
holier94921623_holier
holler93520613_holler
homer105828453_ho_mer
homier116416993_homier
honer85332093_ho_ner
honker134117463_honker
hoofer124014953_hoofer
hooker134820173_hooker
hooper114518313_hooper
hooter94123923_hooter
hoover124314433_hoover
hoper105829143_ho_per
hopper134218483_hopper
hoser811529763_ho_ser
hosier94219613_hosier
hotter94720073_hotter
houser95322283_houser
hover115524133_ho_ver
howler123514313_howler
joiner134114133_joiner
juicer1536283_juicer
loiter64619173_loiter
moiler84017263_moiler
nicer74618293__nicer
noticer937273noticer
officer1534213officer
oiler54628283__oiler
phonier122710633phonier
poiser84217243_poiser
policer113112683policer
pricer103918293_pricer
pumicer1335063pumicer
rejoicer17315343rejoicer
ricer74726613__ricer
schooner1336623schooner
shicker163914823sh_icker
shier85428943sh_i_er
shiner93820873sh_iner
shiver124517373sh_iver
shoaler102610073shoaler
shocker163411423shocker
shoer84722153sho__er
shooter103013973shooter
shopper143312623shopper
shorter103515493shorter
shouter103213073shouter
shover124515983sho_ver
shower124315103sho_wer
showier1339093showier
shriver134712193shriver
slicer84117603_slicer
soccer1038543_soccer
spicer104719313_spicer
splicer114710523splicer
spoiler93310683spoiler
thicker163611023th_icker
thrice114311573thrice_
thriver13479123thriver
toiler63918283_toiler
voice104915323_voice_
voiced123910113_voiced
voicers12348993_voicers
voices114414013_voices
voider103611553_voider
whicker19359773wh_icker
whiner124516633wh_iner
whiter124316393wh_iter
whoever1634103whoever
whooper15297153whooper
whopper17328503whopper
zooier153411233zooi_er

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.1401276364.3
2DLD Change Limit1340273806.95319276.1
3Display Results3803800.1233089.4
 (SQL Overall)1786913807.21624763.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.