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

221 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
schriks1618574(None) 
schrik15206701schrik_
schtiks16184741schtiks
chirks155414842_chirks
schrods1337432schrods
schticks19193952schticks
schtik15185412schtik_
schuits1235822schuits
scries85226822sc_ries
scrims104615932sc_rims
scrips105316032sc_rips
sheiks132510012s_heiks
shirks134814122s_hirks
shrieks14377672s_hrieks
shrike134513242s_hrike
shrikes144412392s_hrikes
shrinks14397912s_hrinks
shris84221442s_hri_s
shtiks13297822s_htiks
acarids105312243acarids
ascarids11438503ascarids
ascaris93613323ascari_s
caries85147623_caries
carks115534213_car_ks
cerias83321973_cerias
chains114819703_chains
chairs114916173_chairs
chais107530313_chai_s
chalks155412143_chalks
charks155219703_charks
checks174912703_checks
cheeks154712783_cheeks
chias104625513_ch_ias
chicks175317593_chicks
chics123920943_ch_ics
chinks155817573_chinks
chins105631463_ch_ins
chips125721253_ch_ips
chirk144516183_chirk_
chirms135113983_chirms
chiros114617773_chiros
chirps135414003_chirps
chirrs114514983_chirrs
chirus114615693_chirus
chis95933313_ch_i_s
chits105424573_ch_its
chocks174815313_chocks
choirs114911873_choirs
chooks155312793_chooks
chrism13710673_chrism
chrisms1499143_chrisms
chucks174812933_chucks
chunks154210333_chunks
corks116028273_cor_ks
cribs94516753_c_ribs
cricks144316053_c_ricks
cries75438403_c_ries
cris66233433_c_ri_s
crits75527573_c_rits
curies84934023_curies
curios83218333_curios
haiks125120933__haiks
ochres113510833ochr_es
ochring13156673ochring
ochrous1237933ochrous
sahibs1137083sah_ibs
sarins63932623s_arins
saris54544953s_ari_s
sarks96632463s_ar_ks
sauries72821623sauries
scabies11613333scabies
scarabs1137293scarabs
scarers94618503scarers
scares85033003scar_es
scarfs114714683scar_fs
scarier94017873scarier
scariest101615943scariest
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scariose1037593scariose
scarious10610203scarious
scarphs14437413scarphs
scarps104718603scar_ps
scars75433533scar__s
scarts85321493scar_ts
scarves124511623scarves
scenics1137773scenics
schavs1436493sch_avs
schemas1468163schemas
schemes1489663schemes
scherzos2243693scherzos
schism1338173sch_ism
schisms1437173schisms
schist11312653sch_ist
schists1248543schists
schizo20115993sch_izo
schizos21115423schizos
schizy23115043sch_izy
schleps1445483schleps
schlocks19245693schlocks
schlubs1443193schlubs
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153sch_mos
schmucks2142763schmucks
schnaps1443703schnaps
schnooks1754243schnooks
schools1249113schools
schorls1248353schorls
schrod1247883schr_od
schtick18194523schtick
schuit1139563schui_t
schuls11299853sch_uls
schuss11186733sch_uss
schwas14396983sch_was
sciurids1143333sciurids
scorers94115313scorers
scores84725923scor_es
scoria8513483scori_a
scoriae9310893scoriae
scorify1535203scorify
scoring103117213scoring
scorns85713013scor_ns
scotias939733scotias
scrags95713803sc_rags
scrams105216623sc_rams
scraps106017243sc_raps
screaks13469353screaks
screes85023963sc_rees
screws115513883sc_rews
scribe104613533sc_ribe
scribes113713203sc_ribes
scried95817303sc_ried
scrim95419723sc_ri_m
scrimp125110583sc_rimp
scrimps13517903sc_rimps
scrip96619193sc_ri_p
script105717903sc_ript
scripts11509373sc_ripts
scrive115414943sc_rive
scrives124414273sc_rives
scrods94111603sc_rods
scrubs104210313sc_rubs
scrums104614253sc_rums
sculks123610263sc_ulks
scurfs113210813scur_fs
scurries102911483scurries
scurvies13248123scurvies
series64540973s_eries
serifs94017053s_erifs
serins64029673s_erins
serries73925353serries
sferics1236133sferics
shacks154817563s_hacks
shanks135315583s_hanks
sharias102516003sharias
sharifs13279903sharifs
sharks135019723s_harks
sheik122514653s_heik_
sheikh16206993s_heikh
sheikhs17233993s_heikhs
sherifs13299683sherifs
shies86136553s_h_ies
shiksa1394653s_h_iksa
shikse1386073s_h_ikse
shims104422543s_h_ims
shins85131043s_h_ins
ships105123773s_h_ips
shires95225573s_hires
shirk124817843s_hirk_
shirrs94413173s_hirrs
shirts94918333s_hirts
shits84731163s_h_its
shivs115018803s_h_ivs
shocks154414573s_hocks
shooks134515623s_hooks
shreds105613053s_hreds
shrews129313913s_hrews
shri76021693s_hri__
shriek134211103s_hriek
shrieky17364803s_hrieky
shrift12413543s_hrift
shrifts1335963s_hrifts
shrill94712303s_hrill
shrills10389933s_hrills
shrimp13478763s_hrimp
shrimps14516753s_hrimps
shrine94920053s_hrine
shrines104618693s_hrines
shrink134511733s_hrink
shrive125216953s_hrive
shrives134416173s_hrives
shrubs11409213s_hrubs
shrugs10469163s_hrugs
shticks16356963s_hticks
shtik123210943s_htik_
shucks154010413s_hucks
smerks12449713smer_ks
smirks124910123smir_ks
snarks104815733snar_ks
sparids103512123sparids
sparks124616363spar_ks
spherics1537073spherics
spiks114117473s__piks
spirits94112623spirits
sprigs94814773s_prigs
sprits85122533s_prits
sris45434153s__ri_s
stirks104914233stir_ks
stories7324273stories
storks106115933stor_ks
stricks134310693s_tricks
strike105619733s_trike
strikes114719093s_trikes
strips85719653s_trips
suchlike1735123suchlike
susliks1136443susliks
thrips11299013_thrips
tughriks1641713tughriks
tugriks1233153tugriks

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.1561145455.1
2DLD Change Limit1340272217.46617951.6
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.70223200.6
 
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.