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

174 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
wittols103573(None) 
wittol935921wittol_
dittos74111972ditto_s
lintols7339552lintols
pistols93213982pistols
wittily1336172wittily
amatols938173amatols
bettors93312473bettors
bitters94920353bitters
bittock1544433bittock
bittocks1644443bittocks
bitts75022593bitt__s
bottoms1136983bottoms
bristols1046773bristols
buttals938503buttals
buttons9310333buttons
cibols1039523ci_bols
cineols9128853cineols
citators10310233citators
citola838393ci_tola
citolas939343ci_tolas
citole8311503ci_tole
citoles9312553ci_toles
citrals91111663citrals
citrons92913223citrons
citrous93112983citrous
cottons9312193cottons
dattos74311903datto_s
diatoms1039073diatoms
diobols1036543diobols
diols65521013di__ols
distils83015803distils
ditties83116983ditties
ditto65315603ditto__
dittoed936733dittoed
dottels8327783dottels
extols1337683_extols
fitters104517743fitters
hitters104717583hitters
idols65514133_i_dols
indols74714203_indols
jettons1437273jettons
jitters144314463jitters
ketols104210763_ketols
kittel10368863kittel_
kittens11347583kittens
kitties113213623kitties
kittle104012173kitt_le
kittles113012493kittles
lictors93212583lictors
lintels73311163lintels
lintol6369473lintol_
listels74212433listels
lithops12307253lithops
lithos94212553litho_s
litotes7311183litotes
litters73422563litters
little63312163litt_le
littles73212783littles
littorals944133littorals
lottos64613103lotto_s
maltols939403maltols
metols84115773_metols
mittens9349883mittens
mitts75523753mitt__s
mottoes93412193mottoes
mottos84615243motto_s
muttons949283muttons
nicols8810243ni_cols
nitinols844413nitinols
nitons64614903ni_tons
nitrils72810703nitrils
nitros64214123nitro_s
nitrous73512483nitrous
ottos54714323_otto_s
outtold8107603outtold
patrols93513513patrols
petrols92913083petrols
phytols15276553phytols
pinitols1046103pinitols
pintoes95117713pintoes
pintos86021293pinto_s
pistils93314303pistils
pistol83313333pistol_
pistole92414313pistole
pistoles102514723pistoles
pistons93016373pistons
pistous92714383pistous
piteous9310683piteous
pitons85319043pi_tons
pittas86014523pitt_as
pottos84615873potto_s
quittors17155413quittors
rattons73815323rattons
retools73411023retools
riotous739863riotous
ritters74020613ritters
rituals738353rituals
santols73513323santols
sitcoms1145533sitcoms
sitters74221543sitters
skatols1135523skatols
sotols63714453_sotols
stools65117023_stools
tattoos738643tattoos
tictocs1145903tictocs
tiptoes939173tiptoes
tiptops1136073tiptops
titters74219613titters
titties73617363titties
tittle63613323titt_le
tittles73413253tittles
tittups933353tittups
tools55325243__tools
twitters11296773twitters
viators102712013viators
victors123311173victors
viols86118103vi__ols
vitals94514303vi_tals
vitriols1145053vitriols
vittle94711753vitt_le
vittles103211113vittles
wadmols1333913wadmols
waitrons1136633waitrons
wantons103713013wantons
wattle94314213watt_le
wattles103814073wattles
watts86923093watt__s
wetters103817753wetters
whitlows1743083whitlows
whitters14359403whitters
whittle13106103whitt_le
whittles1496673whittles
widows1376563wi_dows
widths1335123widt_hs
wigeons1136983wigeons
willows13299743willows
wills84528963wi__lls
wilts85023503wilt__s
windows1447743windows
winnows1334533winnows
winoes94317013wi_noes
winos84625043wi_no_s
winters103720473winters
wintle94014603wint_le
wintles103414983wintles
wisdoms1335453wisdoms
wists86728523wist__s
witans93412933wi_tans
witches152715793witches
wites85536963wi_t_es
withal1238933withal_
withers134417753withers
withes124620843wi_thes
withhold1843433withhold
withholds1952653withholds
withies133913543withies
withins133511693withins
without1348883without
withouts1445113withouts
witless103310983witless
witloof1344353witloof
witloofs1442503witloofs
witness103010013witness
witneys13274723witneys
wits76044873wi_t__s
witted104216813witt_ed
wittier103910823wittier
wittiest112711523wittiest
witting113417063witting
wittings12328733wittings
witty114717013witt__y
wontons103310533wontons
wools84421463w__ools

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.1731032896.0
2DLD Change Limit1340271746.23321502.8
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.46927622.7
 
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.