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

125 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
crypto1336727(None) 
crypt123715231crypt_
cryptos14337211cryptos
crypts13397741crypts
crept95125892crept_
cryptal1445682cryptal
cryptic1646152cryptic
krypton1643282krypton
aristo6414033aristo
calypso1443123calypso
campo115219763camp_o
canto74931013c_anto
capo85829213c_ap_o
captor104914603c_aptor
cento76625173c_ento
chapt125827643chapt_
clapt98027173clapt_
clept95725773clept_
clipt96324273clipt_
clypei1334163clypei
coapt96131533coapt_
coapts104614013coapts
cogito939203cogito
compo115318573comp_o
compt116328223compt_
compts125216653compts
conto76027173c_onto
coopt95929853coopt_
coopts105814583coopts
coranto9311893coranto
cornuto937033cornuto
coyote11411783coyote
coypou13268403coypou
coypu12349873coyp_u
coypus13389303coypus
craft105327663craft_
crafts115312743crafts
crafty14478913crafty
crambo1238043crambo
crap85731843crap__
crape96128443crap_e
craped116120523craped
crapes104727693crapes
crappy15446803crappy
craps95328643crap_s
crate76537403cr_ate
craton84517193cr_aton
create85126373create
creator93714433creator
credo84815563cr_edo
crepe95520723crep_e
creped114115703creped
crepes105419343crepes
crepey135110933crepey
crepon1039933crepon
crepy124812703crep_y
crest74632693crest_
crests85218703crests
cripe95521143crip_e
cripes105120873cripes
crista8311803crista
crit65743713cr_it_
crits75527573cr_its
croft105622683croft_
crofts114910593crofts
crop87628633crop__
crops96125233crop_s
croton84415453cr_oton
croute84617273croute
crouton947133crouton
cruet74831843cruet_
cruets85314953cruets
crust75827663crust_
crusts84916543crusts
crusty114911343crusty
crwth1337483cr_wth
cry89726243cry___
crying123612283crying
cryotron1344373cryotron
cryptogam1953063cryptogam
cryptonym2152263cryptonym
crystal1237433crystal
cyano105512493c_yano
cyclo1237703c_yclo
cyst96322813c_yst_
cysts105912773c_ysts
cyton101511463c_y_ton
decrypt1545703decrypt_
decrypts1642943decrypts
dript86923873dript_
dropt86924433dropt_
drylot1037403drylot
encrypt1445323encrypt_
encrypts1542983encrypts
erupt74220063erupt_
erupts8348903erupts
eryngo1033613eryngo
frypan1434543frypan
gript85126173gript_
grotto7349813grotto
gryphon1643873gryphon
hypo127516353_hyp_o
klepto1244453klepto
kryptons1743223kryptons
presto84216203presto
pronto8313993pronto
rapt67245313_rapt_
raptor83912823_raptor
rato45436973_r_ato
recto74520803_recto
repo66027543_rep_o
repot75132623_repot
repro75315913_repro
roto45935053_r_oto
ryot75528563_ryot_
ryots85313783_ryots
script105717903script_
scripts11509373scripts
trapt76433393trapt_
tryptic1446003tryptic
tryst84716223tryst_
tryste9399583tryste
trysts9448793trysts
typo95418123_typ_o
wrapt105123183wrapt_

Search took 5 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.1261418182.5
2DLD Change Limit1127161254.72023880.5
3Display Results1251250.0304166.7
 (SQL Overall)1786911254.87636647.0
 
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.