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

126 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
toileting103626(None) 
colleting12311052colleting
fileting1239302_fileting
tableting1236342tableting
tilting83417102t_il_ting
toiling83219022toil__ing
toiting83217092toi__ting
billeting1236633billeting
boiling103819673boil__ing
bolting104416763bo_l_ting
bonneting1236173bonneting
bulleting1236643bulleting
coiling103723453coil__ing
collating12312753collating
collecting1548283collecting
competing163712463competing
completing1748413completing
corseting12312173corseting
cosseting1239543cosseting
coveting141912303co_veting
deleting103314423_deleting
depleting1378193depleting
dieting93616833_di_eting
dilating102714903_dilating
diluting10248983_diluting
docketing1785413docketing
epilating12310963epilating
etiolating1146963etiolating
filleting1335843filleting
foiling113317653foil__ing
foisting122910503foi_sting
foliating1339253foliating
galleting1137623galleting
gimleting1343863gimleting
hilting113316893_hil_ting
hoidening1435633hoidening
hoisting123610903hoi_sting
hollering1337743hollering
jilting153211743_jil_ting
jointing16248613joi_nting
joisting16328503joi_sting
jolting153410913jo_l_ting
kilting123213853_kil_ting
lilting83515383_lil_ting
loitering1039683loitering
milting103619123_mil_ting
moiling103417663moil__ing
molesting1237743mo_lesting
molting103517173mo_l_ting
moulting112710313moul_ting
oiling74925313_oil__ing
palleting1238733palleting
pelleting1237953pelleting
piloting1139693_piloting
pocketing1875853pocketing
pointing112813683poi_nting
pollening1236923pollening
polluting1235703polluting
quieting18228463qui_eting
quilting18218713quil_ting
riveting12139443_riveting
rocketing1666973rocketing
roiling83220453roil__ing
roqueting1944603roqueting
rouletting1144753rouletting
silting83320483_sil_ting
socketing1666383socketing
soiling83422323soil__ing
solating9315593so_lating
sonneting1037003sonneting
stilting93312393stil_ting
tabletting1344083tabletting
tailgating1244873tailgating
tailing82923103tail__ing
tailoring1036393tailoring
tainting93613583tai_nting
targeting1137303targeting
telexing1646613t_elexing
telneting1035593telneting
thieving1535143thi_eving
thirsting1335283thirsting
ticketing1635633ticketing
tieing73518763t_i_e_ing
tiering8315243t_i_ering
tiling73426553t_il__ing
tillering1037863tillering
tilling83522773t_il_ling
tincting1148883t_incting
tinting84620603t_i_nting
toasting93410573to_asting
tochering1537153tochering
toeing74418473to__e_ing
toilet66228093toilet___
toileted936993toilet_ed
toiletries1046613toiletries
toiletry1144103toilet_ry
toilets74112913toilet__s
toilette846683toilet_te
toilettes946023toilettes
tokening1336463to_kening
tolerating1148593to_lerating
toling73926123to_l__ing
tolling83418563to_l_ling
tooling82918313tool__ing
tooting83019423to__oting
tormenting1345693tormenting
toting74123793to___ting
tottering10229613tottering
totting82816843to__tting
touting84118453to__uting
toweling122910373to_weling
towelling1366253towelling
towering122610873to_wering
trailering1145713trailering
trilling92815963tril_ling
trinketing1544153trinketing
trisecting1345503trisecting
trolleying1442553trolleying
tweeting12267033t_weeting
twilling12268673twil_ling
twisting12427813twi_sting
twitting12307223twi_tting
valeting1238843_valeting
violating1337423violating
volleying1643763volleying
wilting113515913_wil_ting

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411267.72019254.0
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.93622516.5
 
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.