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

103 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
cryptos1433721(None) 
crypto13367271crypto_
crypts13397741crypt_s
crypt123715232crypt__
cryptal1445682cryptal
cryptic1646152cryptic
krypton1643282krypton
kryptons1743222kryptons
aristos7312373aristos
calypsos1543113calypsos
campos125217953camp_os
cantos84826973c_antos
capos94826073c_ap_os
captor104914603c_aptor
captors113914983c_aptors
centos85920463c_entos
cestos84718093c_estos
clypeus1433243clypeus
coapts104614013coapt_s
cogitos1037613cogitos
compos124818803comp_os
compts125216653compt_s
contos84923233c_ontos
coopts105814583coopt_s
corantos10310103corantos
cornutos1046053cornutos
coyotes12410703coyotes
coypou13268403coyp_ou
coypous14248813coypous
coypus13389303coyp_us
crafts115312743craft_s
crambos1336783crambos
crapes104727693crap_es
craps95328643crap__s
crates85736063cr_ates
craton84517193cr_aton
cratons94316033cr_atons
creates95225203creates
creator93714443creator
creators102814413creators
credos94612853cr_edos
crepes105419343crep_es
crepon1039943crep_on
crepons1139323crepons
crept95125893crept__
crests85218703crest_s
cripes105120873crip_es
crits75527573cr_it_s
crofts114910593croft_s
crops96125233crop__s
croton84415453cr_oton
crotons93714373cr_otons
croutes94815653croutes
crouton947133crouton
croutons1036753croutons
cruets85314953cruet_s
crustose1045503crustose
crusts84916543crust_s
crwths1433433cr_wths
cryotron1344373cryotron
cryotrons1444743cryotrons
cryptogam1953063cryptogam
cryptogams2052693cryptogams
cryptonym2152263cryptonym
cryptonyms2252093cryptonyms
crystal1237433crystal
crystals1347173crystals
custos84014313c_ustos
cyclos1338073c_yclos
cypres1338523c_ypres
cyprus1335363c_yprus
cysts105912773c_yst_s
cyton101511463c_y_ton
cytons111710183c_y_tons
decrypts1642943decrypt_s
drylots1143743drylots
encrypts1542983encrypt_s
erupts8348903erupt_s
eryngos1142733eryngos
frypans1544053frypans
grottos8337333grottos
gryphon1643873gryphon
gryphons1743963gryphons
hypos1312014743_hyp_os
kleptos1344363kleptos
prestos93716083prestos
raptor83912823_raptor
raptors94213353_raptors
ratos55528763_r_atos
rectos85718783_rectos
repos74725793_rep_os
repots85621003_repots
repros84216003_repros
rotos56027883_r_otos
ryots85313783_ryot_s
scripts11509373script_s
skyphos1963733skyphos
tripos84014923trip_os
tryptic1446003tryptic
trystes10419993trystes
trysts9448793tryst_s
typos106015813_typ_os
xystos16356913_xystos

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.420425454.8
2DLD Change Limit1340271036.76619808.9
3Display Results1031030.0303433.3
 (SQL Overall)1786911037.21624763.2
 
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.