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

183 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
risible93792(None) 
rinsible1046291rinsible
risibles1035781risibles
risibly1235641risibly
visible1236921visible
derisible1245772derisible
disable10516432disable
erosible1046442erosible
fusible1237022fusible
miscible1447672miscible
mixible18195092mixible
raisable10311642raisable
resile64627672resi_le
ridable101412492ridable
rinsable10310042rinsable
rissole739782rissole
visibly1535042visibly
addible11236063addible
aisle55223193ais__le
alible8311973_alible
audible10228243audible
bible95119423__bible
bitable11312203bitable
bribable1137223bribable
bristle91910103bris_tle
citable11313463citable
credible1346023credible
crucible1445193crucible
dibble114013843di_bble
dirigible1343173dirigible
disabled1248713disabled
disabler1147913disabler
disables11410903disables
disciple1346673disciple
divisible1544383divisible
dribble12368603dri_bble
drivable1438023drivable
edible969353_edible
elidible1164573elidible
eligible11114693eligible
ensile62616473ensi_le
erasable10511043erasable
erodible1145493erodible
exigible18113683exigible
feasible1376093feasible
fimble133611753fi_mble
finable122213623finable
fishable1637593fishable
fissile10269653fissile
fixable19218193fixable
foible11410383_foible
friable122612563fri_able
fribble14287783fri_bble
frisbee12298513fris_bee
fusibly1535863fusibly
fusile94313493fusi_le
gribble12297273gri_bble
grisaille1042393grisaille
gristle8169223gris_tle
hidable1399403hidable
hirable121612313hirable
icicle1036583_icicle
invisible1446073invisible
irascible1344773irascible
isle45121703_is__le
istle52214713_is_tle
kibble143910953ki_bble
kissable1436853kissable
lapsible1273973lapsible
legible1035833legible
liable81415813li_able
likable13219413likable
linable92214343linable
lisle53916723lis__le
listable10810313listable
livable122010323livable
losable91910953losable
minable112315073minable
misbill1137033misbill
misfile122611553misfile
misrule939353misrule
missable12311533missable
missile92815403missile
mistitle1038523mistitle
mixable18259173mixable
nibble103713283ni_bble
nimble103412943ni_mble
omissible1344093omissible
ossicle944483ossicle
passible1237693passible
pistole92414313pistole
pitiable1238293pitiable
posable112212783posable
possible1245813possible
rabble103818243r_abble
radiable11611303radiable
radiale83813523radiale
radicle103510713radicle
raiseable1147243raiseable
ramble104519973r_amble
rassle63813203ras_sle
ratable91717553ratable
refile95122373refi_le
reliable10313073reliable
remissible1444343remissible
rendible11128353rendible
resale64025543res_ale
rescale93215473rescale
resemble1247313resemble
reside74224933resi_de
residue8689863residue
resiled84621983resi_led
resiles74026543resi_les
resistible1244613resistible
resite64128453resi_te
resize154117723resi_ze
resole64624183res_ole
restable101618443restable
restyle1038763restyle
retable91820403retable
reticle94112623reticle
retile65929673reti_le
retitle73913093retitle
reusable10811273reusable
revile94921613revi_le
revisable1437993revisable
riblet84222443r__iblet
riddle83915713ri_ddle
rideable1158653rideable
ridicule1144393ridicule
riffle124210233ri_ffle
rifle85518333r__ifle
rigidly1235533rigidly
rile45650533r__i_le
rille55728733r__ille
rimple103814583ri_mple
rippable1435383rippable
ripple103413913ri_pple
rise45945233ris___e
rising74025883risi_ng
risings83211893risings
riskily1436413riskily
risque15227453ris_que
rissoles839113rissoles
riviere1036373riviere
roble75223023r__oble
ropable111611333ropable
roselle7310243roselle
rosily93914713rosi_ly
rouble83913313r_ouble
rouille737493rouille
rowable121510303rowable
rubble104315673r_ubble
ruble74521253r__uble
ruinable1039263ruinable
rulable9310533rulable
rumble103718813r_umble
rusine63916593rusi_ne
rustable101511363rustable
rustle63615413rus_tle
rutile65217683ruti_le
sable74732163__sable
seisable10311373seisable
sensible1037853sensible
sidle65124033__sidle
silicle937753silicle
simile83115633simi_le
sizable1839893sizable
tensible1037243tensible
triable92515393tri_able
triscele1045433triscele
triskele1244573triskele
usable84012553_usable
vesicle12217923vesicle
viable111613773vi_able
vincible1544753vincible
virile9313433viri_le
visitable1445873visitable
visive1257873visi_ve
vitiable1337503vitiable
wimble133211923wi_mble
wirable121610963wirable
writable1338753writable

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.403443402.0
2DLD Change Limit1340271835.98622390.1
3Display Results1831830.0603050.0
 (SQL Overall)1786911836.44927708.3
 
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.