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

240 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
schrik1520670(None) 
schriks16185741schriks
schtik15185411schtik
chirk144516182_chirk
schrod1247882schrod
schtick18194522schtick
schtiks16184742schtiks
schuit1139562schuit
scoria8513482scoria
scrim95419722sc_rim
scrip96619192sc_rip
sheik122514652s_heik
shirk124817842s_hirk
shri76021692s_hri_
shriek134211102s_hriek
shrike134513242s_hrike
shrink134511732s_hrink
shris84221442s_hris
shtik123210942s_htik
acari75020283acari_
acarid95017063acarid
acrid86920103ac_rid
ascarid103910713ascarid
ascaris93613323ascaris
cark105539273_car_k
ceria75125353_ceria
ceric94023093_ceric
chai95929903_chai_
chain105723673_chain
chair105519633_chair
chais107530313_chais
chalk144814603_chalk
chark144222713_chark
check164714713_check
cheek145115713_cheek
chi86228653_ch_i_
chia96026623_ch_ia
chic115925203_ch_ic
chick165419133_chick
chid106626403_ch_id
chin96934743_ch_in
chink145321593_chink
chip116726423_ch_ip
chirks155414843_chirks
chirm125317063_chirm
chiro105320343_chiro
chirp124717163_chirp
chirr105015903_chirr
chiru105317153_chiru
chis95933313_ch_is
chit96937463_ch_it
chock164316613_chock
choir105313593_choir
chook146015043_chook
choric133515893_choric
chrism13710673_chrism
chuck164814873_chuck
chunk144812383_chunk
coria75828303_coria
cork106635693_cor_k
crib86323573_c_rib
crick135118753_c_rick
cris66233433_c_ris
crit65743713_c_rit
curia74523763_curia
curie74533033_curie
curio74221203_curio
echoic1339043echoic
haik115526983__haik
ischia1136393isch_ia
ochre103411593ochr_e
ochrea11316643ochrea
ochred12328003ochred
ochres113510833ochres
ochring13156673ochring
ochroid1357903ochroid
ochry13346933ochr_y
sahib10314753sah_ib
sari45444043s_ari_
sarin55239253s_arin
saris54544953s_aris
sark84938973s_ar_k
scar66434203scar__
scarab10310063scarab
scarce104013633scarce
scare75334463scar_e
scared95227293scared
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143scar_f
scarfs114714683scarfs
scarier94017873scarier
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scarp95724103scar_p
scarph13429603scarph
scarps104718603scarps
scarry116311183scarry
scars75433533scar_s
scart76139773scar_t
scarts85321493scarts
scary105222593scar_y
scenic10510513scenic
schav1338313sch_av
schavs1436493schavs
schema1388373schema
scheme1379633scheme
scherzi2143573scherzi
scherzo2153933scherzo
schism1338173schism
schist11312653schist
schizo20115993schizo
schizy23115043schizy
schlep1347093schlep
schlock18235873schlock
schlub1355003schlub
schmo124510203sch_mo
schmoe13328333schmoe
schmos13379153schmos
schmuck2043043schmuck
schnook1654483schnook
schnoz2035643schnoz
scholia1237823scholia
school11410723school
schorl1179803schorl
schorls1248353schorls
schrods1337433schrods
schticks19193953schticks
schuits1235823schuits
schul102510413sch_ul
schuln11256233schuln
schuls11299853schuls
schuss11186733schuss
schwa13426843sch_wa
schwas14396983schwas
sciurid1044923sciurid
scorch13198093scorch
score75526733scor_e
scored94621133scored
scorer84818253scorer
scores84725923scores
scoriae9310893scoriae
scorify1535203scorify
scoring103117213scoring
scorn75817443scor_n
scorns85713013scorns
scotia8310783scotia
scrag85916173sc_rag
scram910621613sc_ram
scrap97120403sc_rap
screak125311053screak
scree720031703sc_ree
screw109318533sc_rew
scribe104613523sc_ribe
scried95817303sc_ried
scries85226823sc_ries
scrimp125110583sc_rimp
scrims104615933sc_rims
scrips105316033sc_rips
script105717903sc_ript
scrive115414943sc_rive
scrod85115063sc_rod
scrub94914203sc_rub
scrum95418193sc_rum
scry96017763sc_r_y
scudi85112163scudi_
sculk115112463sc_ulk
scurf104719323scur_f
scurfs113210813scurfs
scurfy14338763scurfy
scurril945103scurril
scurry11419583scurry
scurvy14386103scurvy
serif84132123s_erif
serin55434443s_erin
shack145321753s_hack
shank125422193s_hank
sharia93116723sharia
sharif122917113sharif
shark126225023s_hark
sheikh16206993s_heikh
sheiks132510013s_heiks
sherif122915233sherif
shim95827843s_h_im
shin75634303s_h_in
ship95228233s_h_ip
shire84727133s_hire
shirks134814123s_hirks
shirr84716923s_hirr
shirt84533893s_hirt
shit76745933s_h_it
shiv105721163s_h_iv
shock144917023s_hock
shook124920153s_hook
shrank13359123s_hrank
shred98125613s_hred
shrew119720163s_hrew
shrieks14377673s_hrieks
shrieky17364803s_hrieky
shrift12413543s_hrift
shrikes144412393s_hrikes
shrill94712303s_hrill
shrimp13478763s_hrimp
shrine94920053s_hrine
shrinks14397913s_hrinks
shrive125216953s_hrive
shrub104814893s_hrub
shrug94512513s_hrug
shrunk13357063s_hrunk
shtick15308013s_htick
shtiks13297823s_htiks
shuck144314533s_huck
smerk115412723smer_k
smirk116612743smir_k
snark95419943snar_k
sori46039833s_ori_
sparid94016933sparid
spark114920893spar_k
spheric14510073spheric
spik105419713s__pik
spirit83519923spirit
sprig85617743s_prig
sprit76736403s_prit
sri35634003s__ri_
sris45434153s__ris
stark95425623star_k
steric8317063steric
stirk95717413stir_k
stork96819693stor_k
stria55723203s_tria
strick124813203s_trick
strike105619733s_trike
strip77524333s_trip
suchlike1735123suchlike
suslik1036373suslik
thrip103012183_thrip
tughrik1542023tughrik
tugrik1134283tugrik

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.1561145455.1
2DLD Change Limit1127162406.08018538.8
3Display Results2402400.0763157.9
 (SQL Overall)1786912406.31228309.7
 
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.