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

233 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
toils5452749(None) 
boils75427191boils
coils75030081coils
foils85025811foils
moils76125741moils
noils55024331noils
oils46337971_oils
roils54826791roils
soils55327981soils
tails55634191tails
tils45739611t_ils
toil46536281toil_
toile54626491toile
toiles63923511toiles
toits55327471toits
tolls54728431tolls
tools55325241tools
ails45654712_ails
anils56326722anils
arils58732202arils
atolls65511352atolls
axils127217502axils
bails75933522bails
boil66335182boil_
bolls75531312bolls
bowls106121432bowls
broils84114172broils
ceils75019402ceils
coals76129602coals
coifs105718702coifs
coil66439652coil_
coins75834552coins
coirs75221052coirs
cols66553082co_ls
cools75632632cools
cowls106922212cowls
deils65722862deils
diols65521012diols
doily95321032doily
doits66223672doits
dolls66126922dolls
dols56943052do_ls
entoils7810732entoils
etoile6312262etoile
etoiles7411292etoiles
evils84114262evils
fails85631482fails
fils75838692_fils
foals85721692foals
foil76433912foil_
foins85523382foins
fools86824202fools
fouls87221432fouls
fowls115518892fowls
goals65521292goals
hails85231642hails
heils85222192heils
hols76946292ho_ls
howls116219222howls
jails125422942jails
joins125818412joins
jowls156214522jowls
kails95525212kails
koels94613902koels
kohls12437802kohls
kois85129392koi_s
loids66220702loids
loins56728422loins
lolls512121732lolls
mails76037772mails
mils66045322_mils
moil65534082moil_
molls75129782molls
mols65948572mo_ls
mools76027172mools
nails55730402nails
nils46132452_nils
noels56418702noels
noil46133242noil_
noily86120992noily
noirs55615462noirs
oil37452052_oil_
oily77932252_oily
owls76022932_owls
pails75833062pails
poilu72316002poilu
poilus82210572poilus
pois66539042poi_s
polis74731162polis
polls74627722polls
pols66044562po_ls
pools74427702pools
rails55937402rails
reoils64516872reoils
roil46235292roil_
roily86121112roily
rolls55326232rolls
rotls55620162rotls
sails55738102sails
soil46138822soil_
sols45448162so_ls
souls55127362souls
spoils84614532spoils
stoics8311112stoics
stools65117022stools
taels56822072taels
tail45443652tail_
tains54936322tains
talls55133432talls
teals56234132teals
teels55726372teels
tells55828942tells
tels46841692t_els
thill85918732thill
thills95515382thills
thins85826322thins
thiols95112762thiols
thirls95012062thirls
this76027382thi_s
tics65729632t_ics
ties45248312t_ies
til36350262t_il_
tile45451442t_ile
tiles55542102t_iles
till45941202t_ill
tills54631702tills
tilt46252422t_ilt
tilts55325612t_ilts
tins45251302t_ins
tips66436762t_ips
tirls54519802tirls
tis37056642t_i_s
tits46145032t_its
toads65621062toads
tobies84521012tobies
todies74223552todies
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
toiled74420322toiled
toiler63918282toiler
toilers74116262toilers
toilet66228092toilet
toilets74112912toilets
toit46353062toi_t
tokes95234972tokes
tola45236332to_la
tolas54532772tolas
told56132202to_ld
tole46052902to_le
toles55147132toles
toll45535262to_ll
tolu45529152to_lu
tolus55024482tolus
tolyls9436962tolyls
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tones56048662tones
tongs65928462tongs
tonics83617862tonics
tons46553052to_ns
tonsils7310182tonsils
tonus56324302tonus
tool46735682tool_
toons55027532toons
toots55331872toots
topes76941762topes
tophs105220052tophs
topics104714582topics
topis76025832topis
topos75726392topos
tops66248122to_ps
toras55540372toras
torcs75123762torcs
tores55352672tores
torics85118352torics
tories65435882tories
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torts56138122torts
torus54329762torus
toss45637972to_ss
totals63115162totals
totes55139682totes
tots46654122to_ts
tours55325862tours
touts54830392touts
towels94314642towels
towies93521192towies
towns86018882towns
tows78545552to_ws
toxics153910202toxics
toxins133314282toxins
toyos87519142toyos
toys78036342to_ys
trails64622512trails
trials64319882trials
tries55742812tries
trigs65423062trigs
trill55122932trill
trills64319852trills
trims75021472trims
triols66117802triols
trios55528092trios
trips74923362trips
troilus736402troilus
trois57226092troi_s
trolls64613942trolls
tuis44829642tui_s
twigs96911172twigs
twill85612722twill
twills9489792twills
twins85118982twins
twirls9478122twirls
twits86015792twits
vails85825932vails
veils84918802veils
viols86118102viols
voids95414672voids
voila84813942voila
voile84719722voile
voiles94616442voiles
wails86631482wails
wools84421462wools
yowls115715432yowls
zorils153810882zorils

Search took 4 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.1701051123.5
2DLD Change Limit538002332.90618513.4
3Display Results2332330.0763065.8
 (SQL Overall)1786912333.15256691.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.