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

357 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
chigger143600(None) 
chiggers1535561chiggers
chugger1445371chugger
bigger104315062_bigger
changer134215542changer
charger133914062charger
chicer134513602chi_cer
chider125116052chi_der
chiefer1536862chiefer
chigoe1237532chigoe_
chigoes1338352chigoes
chiller124112182chiller
chimer135517202chi_mer
chipper163912582chipper
chirker16429322chirker
chirper14359962chirper
chitter124112962chitter
chugged1584822chugged
chuggers1554862chuggers
clinger103812152clinger
clogger11438802clogger
cringer103514242cringer
digger94616082_digger
higgler12369802_higgler
higher134610892_higher
hinger104723332_hinger
hogger114615082_hogger
hugger114713122_hugger
jigger155313052_jigger
nigger89713572_nigger
rigger85616712_rigger
snigger9328372snigger
swigger12338452swigger
trigger9329162trigger
whinger1410810912whinger
achier113914263achi__er
achiever1643843achiever
agger76420893__agger
aligner8108313aligner
bagger104619203_bagger
binger94923453_binger
blogger11448313blogger
bragger113810043bragger
bringer104213353bringer
bugger104418723_bugger
cadger105013903c_adger
cager85229223c__ager
cagier93715933c_agier
cahier113615773cahi__er
ceiler84013963cei_ler
chafer144714573ch_afer
chaffer18389473chaffer
chamber164011063chamber
chamfer17399863chamfer
champer163813413champer
chancer144215633chancer
change124116753change_
changed144214143changed
changers144313203changers
changes134517583changes
chanter123919733chanter
chapter144213853chapter
charge125114213charge_
charged144614023charged
chargers144011323chargers
charges134615983charges
charier124317903charier
charmer144913663charmer
charter123918303charter
chaser114918383ch_aser
chaster124718503chaster
chatter124416643chatter
chaufer15347943chaufer
chawer144314413ch_awer
cheaper144010583cheaper
cheater124816963cheater
checker18329533checker
cheder125113493ch_eder
cheeper143610743cheeper
cheer105420383ch__eer
cheerer123511753cheerer
chegoe1237273chegoe_
chegoes1337333chegoes
chequer2135153chequer
chewer145512613ch_ewer
chewier1537583chewier
chicaner1586073chicaner
chichier1836023chichier
chickee183111553chickee
chicken18278983chicken
chicle134312543chicle_
chicles143512503chicles
chidden14255223chidden
chide115321013chi_de_
chided135113963chi_ded
chiders135312943chi_ders
chides124620473chi_des
chief134419483chi__ef
chiel104918973chi__el
chignon1344623chignon
childe124711213childe_
childes134211273childes
chile105626893chi_le_
chiles115425303chi_les
chilies124218303chilies
chilled133310933chilled
chillers133710923chillers
chillier13328423chillier
chimaera1564943chimaera
chimar133911473chi_mar
chime125322593chi_me_
chimed145814833chi_med
chimera14389273chi_mera
chimere144010633chi_mere
chimers144515143chi_mers
chimes134922573chi_mes
chimley1785163chimley
chimney1795483chimney
chine105231723chi_ne_
chined125620063chi_ned
chines115029173chi_nes
chinked174011023chinked
chinkier17377363chinkier
chinned134810493chinned
chipped174110813chipped
chippers173510883chippers
chippier17297673chippier
chirked173810333chirked
chirmed15379733chirmed
chirped15379783chirped
chirpers15358133chirpers
chirpier15276303chirpier
chirr105015903chi__rr
chirre114111853chirre_
chirred133612123chirred
chirren12388743chirren
chirres123812253chirres
chisel112111943chi_sel
chiseler1335903chiseler
chitters133711173chitters
chive135117623chi_ve_
chives144317593chi_ves
chivied16368383chivied
chivies153412853chivies
choicer14197893choicer
choker154314373ch_oker
chokier1638043chokier
choler113717153ch_oler
chomper163810073chomper
chooser124412973chooser
chopper163611893chopper
chouser125212943chouser
chowder16387803chowder
chudder14245943chudder
chuffer18337143chuffer
chukker1543833chukker
chunter123911483chunter
churner12298343churner
cider84723313c_i_der
cigar8911803c_i_gar
cinder94119123c_inder
cipher133710263c_ipher
citer74827333c_i_ter
cither114616683c_ither
clagged12749233clagged
clanger104113493clanger
clicker154111883clicker
climber13449133climber
clinged113310093clinged
clingers113810663clingers
clingier1155853clingier
clinker133811663clinker
clipper133710323clipper
clogged12528653clogged
cloggers12437283cloggers
cloggier1244253cloggier
codger105814853c_odger
cogged116416613c_ogged
coigne94612193coigne_
coigned11418663coigned
coignes103912153coignes
coiler84421593coi_ler
coiner84323783coi_ner
coinfer12419393coinfer
cointer93616723cointer
conger95024273c_onger
cosigner1135953cosigner
cougher133711733cougher
cragged12479883cragged
craggier12116063craggier
cribber13367663cribber
crier74724463cri__er
crimmer133310773crimmer
crimper136510423crimper
cringe93515483cringe_
cringed113312403cringed
cringers112511873cringers
cringes103215503cringes
crisper113511053crisper
critter94113033critter
dagger95017303_dagger
digged104314653_digged
diggers104413393_diggers
dinger85323673_dinger
dogger95216783_dogger
dragger10309173dragger
egger74414403__egger
feigner1135593feigner
figged124013893_figged
finger104920333_finger
flagger12469353flagger
flinger113710513flinger
flogger12449463flogger
fogger114414783_fogger
frigged13439053frigged
gagger95016513_gagger
gigged104112293_gigged
giggler101029883_giggler
ginger84920033_ginger
hagged124317703_hagged
haggler12328933_haggler
hanger104023253_hanger
hedger114912633_hedger
hider95024083_hi_der
higgle113811743_higgle
higgled13339073_higgled
higglers13297233_higglers
higgles123911803_higgles
hiker125119393_hi_ker
hiller94421633_hiller
hinder104120063_hinder
hinge95323453_hinge_
hinged114618923_hinged
hingers113420213_hingers
hinges105121033_hinges
hinter94021303_hinter
hipper133818023_hipper
hirer85423123_hi_rer
hisser94713793_hisser
hither124417253_hither
hitter94419863_hitter
hogged125817773_hogged
hoggers124512483_hoggers
hogget114715763_hogget
huger94914873_h_uger
hugged124113643_hugged
huggers124211593_huggers
hunger104015203_hunger
igged86012763__igged
jagger154016003_jagger
jigged164412773_jigged
jiggers164010183_jiggers
jiggier16377823_jiggier
jogger154713163_jogger
kegger12388063_kegger
lagger85919833_lagger
liger65024473_li_ger
linger75226003_linger
logger86420003_logger
lugger83916553_lugger
mugger103914703_mugger
nagger84016123_nagger
niggers93111323_niggers
niggler93610293_niggler
nigher103612753_nigher
philter12108213philter
pigged114214153_pigged
piggery14266193_piggery
piggier113510003_piggier
pinger94324093_pinger
plugger11378423plugger
prigged12398923prigged
priggery1543993priggery
progger11319373progger
rejigger1743183rejigger
rigged94517403_rigged
riggers93613843_riggers
ringer74526063_ringer
rugger84414513_rugger
sagger84321073_sagger
schiller13296473schiller
schizier2234063schizier
shagged134210123shagged
shaggier13116053shaggier
shicker163914823shicker
shier85428943shi__er
shifter132911073shifter
shikker13277023shikker
shimmer143310873shimmer
shiner93820873shi_ner
shingler12268633shingler
shinier104113143shinier
shipper143514043shipper
shirker143711343shirker
shiver124517373shi_ver
shogged13397953shogged
sigher103813703_sigher
signer74015633_signer
singer74227313_singer
slinger83413833slinger
slogger94310483slogger
slugger93610673slugger
smugger11327053smugger
sniggers10317093sniggers
sniggler10396113sniggler
snugger9318313snugger
sprigger12366493sprigger
stagger94212393stagger
stinger84314683stinger
swagger12389333swagger
swigged13327183swigged
swiggers13337123swiggers
swinger113812563swinger
tagger84017703_tagger
thicker163611023thicker
thighed1535273thighed
thinker143610683thinker
thinner10358973thinner
thither13328103thither
thuggee1245263thuggee
thuggery1642563thuggery
tiger65718633_ti_ger
trigged10359853trigged
triggers10257843triggers
tugger84013103_tugger
twigged13345283twigged
twiggen12333503twiggen
twiggier1333073twiggier
wagger113616013_wagger
weigher14136343weigher
whicker19359773whicker
whiffer19105323whiffer
whimper17297723whimper
whiner124516633whi_ner
whinge134311543whinge_
whinged15409153whinged
whingers15358723whingers
whinges143610633whinges
whinier134110633whinier
whipper173611383whipper
whirler13307603whirler
whisker17367933whisker
whisper15298013whisper
whiter124316393whi_ter
whither163510253whither
whitier133311063whitier
whitter139110893whitter
whizzer2134583whizzer
wigged124413583_wigged
wiggery15295873_wiggery
wiggier12418863_wiggier
wiggler123110763_wiggler
winger104125443_winger
wriggler13295263wriggler
wringer113612453wringer
zigged184110193_zigged
zinger163816703_zinger

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273575.95622502.9
3Display Results3573570.1402550.0
 (SQL Overall)1786913576.24928595.1
 
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.