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

144 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
scribal113796(None) 
scribble14175432scribble
scribbly17143622scribbly
scribe104613532scrib_e
scribed124510642scribed
scriber113910972scriber
scribes113713202scribes
scrotal938492scrotal
serial64625862seri_al
tribal8611132_tribal
achiral12109183achiral
acrobat11411813acrobat
actinal9312293actinal
aerial64625713aeri_al
arriba867683arriba_
arrival1037563arrival
ascribable1643483ascribable
ascribe1147743ascrib_e
ascribed1374693ascribed
ascribes1246193ascribes
atrial65418943atri_al
barbal104016663bar_bal
bridal9511453_bridal
burial84117623buri_al
cabal95222153_c_abal
carinal94318233carinal
ceiba938703_ceiba_
ceibas1038503_ceibas
chiral114614413_chiral
chital114313883_chital
cibol9512023_c_ibol
clinal8311553_clinal
coital84117053_coital
craal74117753_cr_aal
credal9311673_credal
crib86323583_crib__
cribs94516753_crib_s
crissal937413_crissal
crural8610633_crural
curial84019153curi_al
cymbal15236913_cymbal
decrial10310323decri_al
ferial94621253feri_al
herbal112513493her_bal
ischial1246423ischi_al
lacrimal1244443lacrimal
lyrical1236493lyrical
marital92314183marital
narial6317953nari_al
pibal95217323__pibal
primal104014623_primal
rial45938093__ri_al
ribald9209293__ribald
rival85216503__rival
riyal84413433__riyal
sabal75422483s__abal
sacral83414413sacr__al
sahiwal1344443sahiwal
sambal105215183s_ambal
scandal1038673scandal
scenical1247133scenical
scilla8310943sc_illa
scleral937863scleral
scoria8513503scori_a_
scoriae9310903scori_ae
scrabble14196993scrabble
scrabbly17164623scrabbly
scrag85916173scr__ag
scram910621623scr__am
scrap97120403scr__ap
scrawl11208093scr_awl
screak125311063scr_eak
scream104814253scr_eam
screwball1662513screwball
scribbled16174033scribbled
scribbler15164223scribbler
scribbles15184953scribbles
scribers12307963scribers
scribing13238183scribing
scried95817303scri_ed
scries85226823scri_es
scrieve12448333scrieve
scrim95419743scri__m
scrimp125110583scri_mp
scrimps13517903scrimps
scrimpy16486133scrimpy
scrims104615933scri_ms
scrip96619193scri__p
scrips105316033scri_ps
script105717903scri_pt
scripts11509373scripts
scrive115414943scri_ve
scrived134511113scrived
scrives124414273scrives
scroll8310173scr_oll
scrota8310203scrota_
scrub94914203scrub__
scrubby1642803scrubby
scrubs104210313scrub_s
scuba94211593sc_uba_
scubas103710223sc_ubas
scumbag1443573scumbag
semibald1344563semibald
seminal91213413seminal
seral56336383ser__al
serials73919743seri_als
serosal7311153serosal
serumal938783serumal
serval93913413ser_val
shibah14387473s_hibah
shrieval1443363shrieval
shrill94712303shri_ll
shrivel13479403shrivel
sial45938833s__i_al
sibyl1037113s__ibyl
sisal54217733s__isal
social8813333soci_al
somital939403somital
sororal7310653sororal
spinal84915313s_pinal
spiral83715343s_piral
spital83813873s_pital
springal1145973springal
sterical10311253sterical
stibial946583s_tibial
stoical9310283stoical
stratal72710603stratal
stria55723213stri_a_
striae65422273stri_ae
strigil837263strigil
strobil936963strobil
stromal93010593stromal
sural55931263sur__al
surgical1146253surgical
surreal739233surreal
survival1443923survival
trial54926353_tri_al
tribals9610753_tribals
trinal6516963_trinal
urial54823023_uri_al
urinal6614123_urinal
verbal112513663ver_bal
zariba1736983zariba_
zaribas1836043zaribas

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.406440125.6
2DLD Change Limit1340271445.98622390.1
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.43827755.7
 
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.