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

109 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
morseling123807(None) 
morselling1346321morselling
corbeling1439032corbeling
corseting12312172corseting
hirseling1396272hirseling
houseling1337482houseling
marveling1537102marveling
modeling12311072mo_deling
moseying1436852mo_seying
worsening1345552worsening
barreling1238043barreling
bordering1338823bordering
boweling143410683bo_weling
chiseling1536403chiseling
coarsening1345543coarsening
consoling12310873consoling
corbelings1544073corbelings
corbelling1546713corbelling
cordelling1446383cordelling
cornering12311893cornering
cosseting1239543cosseting
counseling1345463counseling
creeling113513363_creeling
dieseling1146143dieseling
doweling13279763do_weling
farseeing1344383farseeing
ferreling13136253ferreling
firstling1334423firstling
foreseeing1444553foreseeing
foresting13311363foresting
forewing1539003for_ewing
forsaking1745163forsaking
gosling93312403go_s_ling
groveling1435573groveling
grueling1078273_grueling
hanseling1338063hanseling
hireling121210993hir_eling
hirselling1444833hirselling
hirsling1277543hirs_ling
hoarsening1444403hoarsening
horselike1646263horselike
horsemint1447123horsemint
horsing113215583hors__ing
hoseying1537193ho_seying
hosteling1337893hosteling
houselling1445753houselling
hoveling15189593ho_veling
jostling16207123jo_stling
kerneling1464403kerneling
loosening1044933loosening
lordling1077743lor_dling
marbling13179883mar_bling
marcelling1545593marcelling
marketing1636513marketing
marling103322763mar__ling
marshaling1645073marshaling
marvelling1645363marvelling
misrelying1645503misrelying
misruling1237493misruling
modelings1335553mo_delings
modelling1336883modelling
modeming1437103mo_deming
moiling103417663mo__iling
moistening1346233moistening
moldering1367853moldering
molesting1237743molesting
mongering13310353mongering
monkeying1944473monkeying
morning103215043mor__ning
morphing1637553mor_phing
morsel85815893morsel___
morseled1147193morsel_ed
morselled1245953morselled
morsels94112653morsel__s
mortaring1237933mortaring
morticing1448013morticing
mortising1238693mortising
moshing134214883mo_s_hing
mossing103915423mo_s_sing
mothering152110183mothering
mottling11197753mo_ttling
mouselike1545013mouselike
mousing103816273mous__ing
mousseline1253063mousseline
moussing1138143mous_sing
murdering1357123murdering
muscling1337853m_uscling
nursling997603nurs_ling
ordering1039343_ordering
parceling1438443parceling
pommeling1643873pommeling
portering122012303portering
reeling83126863__reeling
roweling122811123ro_weling
snorkeling1542973snorkeling
streeling10189483streeling
tasseling1035853tasseling
teaseling1036913teaseling
tinseling1036643tinseling
tousling938793tous_ling
toweling122910373to_weling
troweling1376363troweling
unreeling1038983unreeling
warsling12198593wars_ling
warstling1335063warstling
weaseling1335613weaseling
worldling1442893worldling
worsting1267683wors_ting
yodeling1357673yo_deling

Search took 9 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 Limit1486411098.48317522.2
3Display Results1091090.0631730.2
 (SQL Overall)1786911098.71620501.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.