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

141 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
theelins113764(None) 
theelin1038001theelin_
heeling113618512_heeling
heelings12359752_heelings
theelols1144412theelols
theins95015422th_e_ins
theremins14106052theremins
wheelies1437862wheelies
wheeling15318592wheeling
wheelings16284932wheelings
yeelins1038812_yeelins
atheling1249203ath_eling
athelings1345113ath_elings
beeline93314723_beeline
beelines103312803_beelines
berlins93216013_berlins
capelins12311133capelins
cheeking18349083cheeking
cheeping16329553cheeping
cheering143612703cheering
cheerios13317583cheerios
cheesing14349413cheesing
chitlins13289393chitlins
creeling113513363creeling
feeling113617073_feeling
feelings12338933_feelings
gherkins1643993gherkins
gremlins1136053gremlins
haemins122811403_haemins
healing113922963_healing
heeding123515063_heeding
heelers103815623_heelers
heels85625533_heel__s
heezing20349873_heezing
heiling113616363_heiling
helios94816633_h_elios
helling114623223_helling
hellions11310023_hellions
hemins113417573_h_emins
hemline12311073_hemline
hemlines13310623_hemlines
heroins103518013_heroins
hyalins13229273_hyalins
javelins18277733javelins
keeling123515123_keeling
kneeling13287783kneeling
kremlins1444483kremlins
merlins93015813_merlins
metheglins1653103metheglins
myelins1237353_myelins
peeling102919873_peeling
peelings11339523_peelings
ravelins113011603ravelins
reeling83126863_reeling
reelings94012563_reelings
reheeling13218263reheeling
seeling83522003_seeling
shealing123415463shealing
shealings13317563shealings
sheenies111411543sheenies
sheening123010803sheening
sheens95116993shee__ns
sheering123715103sheering
sheeting122712833sheeting
sheetings13256713sheetings
shelling123515213shelling
shieling123512403shieling
shielings13237123shielings
speeling112713123speeling
steelies8312553steelies
steeling93615143steeling
streeling10189483streeling
tameins9311423tame_ins
tapeline10310363tapeline
tapelines1138463tapelines
teeing73916973t_ee_ing
teels55726373t_eel__s
teeming103513093t_eeming
teens56227483t_ee__ns
teflons1036543t_eflons
tellies73820503t_ellies
telling83321083t_elling
tenpins9410073t_enpins
thebaine1355423thebaine
thebaines1454963thebaines
theelol1044273theel_ol
thegns10547433th_e_gns
thein85919023th_e_in_
theine94814923th_e_ine
theines104013233th_e_ines
theirs94610353th_e_irs
thelitis1147513th_elitis
theming133610473th_eming
thens85921833th_e__ns
theologs1246153theologs
theories11311593theories
therein102310353therein_
theremin13107283theremin_
therians1138313therians
thermions1445333thermions
thermits1338513thermits
thesis94913733th_esi_s
thespians1442843thespians
thewless1433923thewless
thiamins1346633thiamins
thiazins2045313thiazins
thieving1535143thieving
thins85826333th___ins
thionins1177923thionins
thirling12248583thirling
tholepins1443963tholepins
tholing112812333th_oling
threeping15104803threeping
thulias1035743th_ulias
tiepins939463t_iepins
timeline1039243timeline
timelines1148443timelines
toweling122910373toweling
towelings13234693towelings
trebling1139873trebling
treeing83414303tree_ing
treelawns1242043treelawns
treeless839283treeless
treelike1237003treelike
treens65317873tree__ns
trellis739873trelli_s
tubulins10106293tubulins
tweedling1442533tweedling
tweenies11146393tweenies
tweens9489843twee__ns
tweeting12267033tweeting
tweezing21384113tweezing
wheedling1733073wheedling
wheelers14287733wheelers
wheelie1336193wheeli_e
wheels123811713wheel__s
wheens124610613whee__ns
wheeping17337103wheeping
wheepling1843323wheepling
wheezing24315383wheezing
yeelin939343_yeelin_

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621416.72021750.3
3Display Results1411410.0602350.0
 (SQL Overall)1786911417.20324807.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.