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 “orderlinesses” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
orderlinesses145338(None) 
elderlinesses1453252elderlinesses
orderliness1243062orderline_s_s
ornerinesses1246552orner_inesses
lordlinesses1345153lord__linesses
miserlinesses1554663miserlinesses
motherlinesses1962353motherlinesses
beerinesses1398904_beer_inesses
borderlines1443254borderlin___es
breezinesses2343944br_eezinesses
brotherlinesses2071244brotherlinesses
burlinesses1338394__burlinesses
cheerinesses1765824cheer_inesses
comelinesses1666394come_linesses
comradelinesses2061394comrade_linesses
cordialnesses1654554cordial_nesses
creakinesses1845984cr_eakinesses
creaminesses1646124cr_eaminesses
creepinesses1645254cr_eepinesses
cruelnesses1346244crue_l_nesses
crumblinesses1952884crumblinesses
curlinesses1338724__curlinesses
dailinesses1249494__dailinesses
deadlinesses1446224__deadlinesses
dewinesses1438344__de_winesses
dirtinesses1239874__dirtinesses
dorkinesses1647654__dorkinesses
dreaminesses1545704dr_eaminesses
drearinesses1347434dr_earinesses
dressinesses1245524dr_essinesses
earlinesses11311034__earlinesses
eerinesses10612574__eer_inesses
elderliness1242854elderline_s_s
fatherlinesses2052614fatherlinesses
fierinesses1439234_fier_inesses
freakinesses1945584fr_eakinesses
friendlinesses1852214friendlinesses
germinesses1437874__germinesses
gingerlinesses1652684gingerlinesses
godlinesses1337124god__linesses
greasinesses1347034gr_easinesses
greedinesses1446454gr_eedinesses
grislinesses1345824gr_islinesses
gristlinesses1443984gristlinesses
growlinesses1644724gr_owlinesses
homelinesses1765354home_linesses
jerkinesses2246054__jerkinesses
leerinesses11119474_leer_inesses
livelinesses15145624live_linesses
lonelinesses12146344lone_linesses
lovelinesses15125334love_linesses
lubberlinesses1851734lubberlinesses
maidenlinesses1751974maidenlinesses
mannerlinesses1652404mannerlinesses
masterlinesses1673524masterlinesses
mealinesses13310974__mealinesses
merrinesses1358254__merrinesses
modernnesses1543864moder_nnesses
nerdinesses1249044__nerdinesses
nervinesses1437304__nervinesses
oilinesses101512434o___ilinesses
orderless1044314orderl__e_s_s
orderlies1045454orderli____es
ordinarinesses1552354ordinarinesses
orneriness1045444orner_ine_s_s
othernesses1475414other__nesses
overtnesses1448694o_ver_tnesses
paperinesses1646044paper_inesses
perkinesses1748914__perkinesses
portlinesses1446974por__tlinesses
preppinesses1544874pr_eppinesses
prettinesses1447514pr_ettinesses
pricklinesses2143614pricklinesses
priestlinesses1652704priestlinesses
queenlinesses2252274queenlinesses
readinesses12611264_r_eadinesses
realnesses10310844_r_eal_nesses
reedinesses1259554_r_eedinesses
seemlinesses1445224_seemlinesses
sorrinesses11310084sor__r_inesses
steelinesses1246724_steelinesses
surlinesses11310044__surlinesses
timelinesses1445454time_linesses
trendinesses1346324tr_endinesses
waterinesses1567194water_inesses
wifelinesses1844814wife_linesses
wordinesses15138874word___inesses
worldlinesses1752804wor_ldlinesses

Search took 6 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 Filter178691950240.1231452772.4
2DLD Change Limit95024885.04618831.5
3Display Results88880.0631396.8
 (SQL Overall)178691885.23234153.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.