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 “risus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
risus5421639(None) 
nisus56014391nisus
rises55244041rises
risks94917061risks
arises65233802arises
bises75435622bises
bisks115416802bisks
brises84927612brises
brisks124611402brisks
briss75824272bris_s
casus76419252casus
cists76624532cists
cistus84611342cistus
crises84529432crises
crisis83716342crisis
crisps104411512crisps
discs85316262discs
discus94512112discus
disks105417472disks
diss56434482dis_s
disuse74012842disuse
ficus105015492ficus
fiscs105311882fiscs
fists85527542fists
frises94124272frises
frisks13479262frisks
gists66026192gists
grists74716482grists
hilus84817642hilus
hiss75629212his_s
hists86328372hists
irises64221172irises
isms66213472_isms
jisms14458002jisms
kiss85227402kis_s
kists95822112kists
krises105016082krises
lieus56218482lieus
lisps76913912lisps
lists56628692lists
lusus54813872lusus
minus75223932minus
mises74740562mises
misos76523292misos
miss65339422mis_s
missus85312292missus
mists76633902mists
misuse83213642misuse
nidus65913572nidus
pilus75921062pilus
pious74621272pious
pisos76021062pisos
piss65033332pis_s
primus103712172primus
prises84133172prises
prisms104915502prisms
priss74623892pris_s
raises64826542raises
rakus94413672rakus
ramus76418282ramus
rases55447212rases
rasps74316662rasps
rebus75721112rebus
rests54935872rests
rhesus936202rhesus
rhus75114052r_hus
rials55026672rials
rias45540592ri_as
ribes75530172ribes
ribs65833022ri_bs
rices75536152rices
ricks115126132ricks
rictus8379192rictus
rides66140812rides
rids56539552ri_ds
riels55121332riels
riffs115114612riffs
rifs74929002ri_fs
rifts85718642rifts
rigs55137592ri_gs
riles55343642riles
rills55032712rills
rimes75634542rimes
rimous8311912rimous
rims65936302ri_ms
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192ri_ns
rinses64720382rinses
riots54922012riots
ripes75435772ripes
rips66237432ri_ps
rise45945232ris_e
risen54621882risen
riser55431052riser
risers64624782risers
rishi8311252rishi
rishis9312452rishis
risk85724102ris_k
risky126311522risky
risque15227452risque
risuses73210922risuses
rites54442552rites
rives85336002rives
roses56445772roses
rubus76415062rubus
ruses56136582ruses
rusks95816192rusks
rusts55026992rusts
sinus55523852sinus
sises55233832sises
situs55019232situs
trismus935562trismus
virus85316842virus
visas84317652visas
viscus11428502viscus
vises84427772vises
wises85633192wises
wisps105214182wisps
wiss75630542wis_s
wists86728522wists
wrists95415642wrists

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001231.48636204.6
3Display Results1231230.0304100.0
 (SQL Overall)1786911231.84297009.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.