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

149 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
visible123692(None) 
risible937921risible
visibly1535041visibly
disable10516432disable
divisible1544382divisible
fusible1237022fusible
invisible1446072invisible
miscible1447672miscible
mixible18195092mixible
rinsible1046292rinsible
risibles1035782risibles
risibly1235642risibly
vesicle12217922vesicle
viable111613772vi_able
vincible1544752vincible
virile9313432viri_le
visitable1445872visitable
visive1257872visi_ve
vitiable1337502vitiable
addible11236063addible
advisable1544573advisable
aisle55223193ais__le
alible8311973_alible
audible10228243audible
bible95119423__bible
bitable11312203bitable
citable11313463citable
derisible1245773derisible
devisable1546853devisable
dibble114013843di_bble
disabled1248713disabled
disabler1147913disabler
disables11410903disables
disciple1346673disciple
divisibly1843233divisibly
edible969353_edible
elidible1164573elidible
eligible11114693eligible
ensile62616473ensi_le
erosible1046443erosible
evadible1443973evadible
eversible1475443eversible
evincible1642563evincible
evitable1339323evitable
exigible18113683exigible
feasible1376093feasible
fimble133611753fi_mble
finable122213623finable
fishable1637593fishable
fissile10269653fissile
fixable19218193fixable
foible11410383_foible
fusibly1535863fusibly
fusile94313493fusi_le
hidable1399403hidable
hirable121612313hirable
icicle1036583_icicle
invisibles1543453invisibles
invisibly1745033invisibly
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
raisable10311643raisable
resile64627673resi_le
revisable1437993revisable
ridable101412493ridable
rinsable10310043rinsable
rissole739783rissole
sable74732163__sable
seisable10311373seisable
sensible1037853sensible
sidle65124033__sidle
silicle937753silicle
simile83115633simi_le
sizable1839893sizable
subvisible1752663subvisible
tensible1037243tensible
usable84012553_usable
vagile10310543vagi_le
variable13310063variable
variole10711593variole
vehicle15175253vehicle
vendible14156473vendible
verbile1249863verbile
versicle1366583versicle
vesicae12177703vesicae
vesicles13127073vesicles
vestibule1443693vestibule
viably14199833vi_ably
vibe95124503v__ib_e
viewable1635223viewable
vigil94313003vigi_l_
vigils104210193vigi_ls
vile76139803v__i_le
vincibly1843583vincibly
violable1337543violable
virgule1144283virgule
visage1049083vis_age
viscidly1753303viscidly
viscose1237863viscose
vise75632673vis___e
vising103915873visi_ng
vision9311313visi_on
visioned1247013visioned
visions10311023visions
visit8320963visi__t
visited1168773visited
visiter1038863visiter
visitor1046203visitor
visits9311423visi_ts
visual938803visual_
visuals1036853visuals
vitiate103412953vitiate
vittle94711753vi_ttle
vividly1744233vividly
vocable14189673vocable
voidable1466853voidable
voile84719723v_oi_le
voluble1244503voluble
votable122111373votable
wimble133211923wi_mble
wirable121610963wirable

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.1561145455.1
2DLD Change Limit1340271497.00019146.7
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.21924752.9
 
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.