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

157 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
crocein113807(None) 
croceine1248031croceine
croceins1238101croceins
acrolein1045852acrolein
cocain101315012c_ocain
cochin131313202c_ochin
codein94916722c_odein
croceines1347732croceines
croci95818132croc_i_
crocine11314152croc_ine
crocking174313442crocking
orcein838182or_cein
prochein1547522prochein
protein92414732protein
acrogen1038203acroge_n
acroleins1145543acroleins
broken124011523broke_n
bromelin1246343bromelin
bromin102615693bro_min
brucin1049133bruc_in
caffein1535333caffein
carotin92216733caro_tin
casein83216453c_asein
chocking204011013chocking
chopin132712193cho_pin
choreic1438703choreic
chosen116014133chose_n
clocking174312413clocking
cloven114211513clove_n
cocaine111315173c_ocaine
cocains111313923c_ocains
cocci82812673c_occi_
coccic8298943c_occic
coccid102910743c_occid
cochins141413103c_ochins
cocking163619983c_ocking
cocoon10312263c_ocoon
codeia94112193c_odeia
codeina104010323c_odeina
codeine103815033c_odeine
codeins103715483c_odeins
coden86128543c_ode_n
codlin94516443c_odlin
coffin14339813c_offin
coheir1137583c_oheir
coin66645353c_o__in
cojoin1539503c_ojoin
colin76231693c_o_lin
conceit113218073conceit
concern113011963concern
conin76232723c_o_nin
cooeeing1137453cooeeing
copen94826433c_ope_n
corbeil11859213corbeil
coreign1037343c_oreign
cortin82423153c_ortin
cousin8517163c_ousin
coven106925043c_ove_n
covin105621123c_o_vin
cozen165019703c_oze_n
cracking174013903cracking
craven114113933crave_n
creatin93618133creatin
cretin82917913cr_etin
cricetid1345193cricetid
cricking173412653cricking
cricoid1239243cricoid
croaking153712163croaking
croc85723733croc___
crochet143616663crochet
crocheting1844703crocheting
crochets15359833crochets
crock135921993croc__k
crocked164014433crocked
crockery19356603crockery
crocket154615673crocket
crockets16339543crockets
crocks145118423croc_ks
crocoite1248053crocoite
crocs95722433croc__s
crocus104813173croc_us
crojik1934113cro_jik
crone75231333crone__
crones84729243crone_s
cronies9622503cronies
crooking153611343crooking
croon75522783cro__on
crooning113112113crooning
croppie13278793croppie
cropping153210883cropping
croquis1834763croquis
crore74922873crore__
crores86121163crore_s
crosier94116573crosier
crossing112612683crossing
crostini1038293crostini
crostino1038883crostino
croton84415453cro_ton
crouching1746383crouching
crouton947133crouton
crowdie1335913crowdie
crowding15247933crowding
crowed124717303crowe_d
crower114117563crowe_r
crowers124614903crowers
crowing133814763cro_wing
crown105620083cro__wn
crowning143510033crowning
croze164719453croze__
crozer175112843croze_r
crozers184111083crozers
crozes174417663croze_s
crozier18369933crozier
cruces105117543cruce_s
crucian1146283crucian
cryogen1345043cryoge_n
cyclin1339273c_yclin
cystein1246053cystein
frocking18309573frocking
frozen18408443froze_n
grocer94212143groce_r
grocers103511253grocers
grocery13336763grocery
groin65521083gro__in
hordein1138753hordein
kronen10348913krone_n
lomein8410203_lomein
marocain1247063marocain
narcein936293narcein
ocean71212963__ocean
olein5316003__olein
orceins937743or_ceins
orcin72716573or_c_in
procaine12312273procaine
proceed12310553proceed
process11310403process
prochain1548483prochain
protean92412193protean
protei82615313protei_
proteid103513673proteid
proteins102114283proteins
proven114314773prove_n
recoin84320293_recoin
rein46040893_r__ein
ricin74620213_ric_in
robbin103611183_robbin
robin74820283_ro_bin
rocking143619633_rocking
rosin55325313_ro_sin
rouen54920903_roue_n
roven85521973_rove_n
rowen84921153_rowe_n
tocsin8311003_tocsin
trochil1258713trochil
trocking153612423trocking
tropin83316753tro_pin
urchin1138743ur_chin

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.420425454.8
2DLD Change Limit1340271576.05022153.2
3Display Results1571570.0463413.0
 (SQL Overall)1786911576.51627423.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.