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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
postlanding154383(None) 
islanding1135623_is_landing
pollarding1444233po_llarding
portending1446193port_ending
postdating1447163postda_ting
postmarking2053693postmarking
postmating1548603postma_ting
postponing1555743postpon_ing
postsyncing1951773postsyncing
postulating1447503postula_ting
postweaning1752873postwean_ing
standing103413633__st_anding
stranding1149653__stranding
upstanding1443713upst_anding
astounding1244154_astounding
bastinading1573554bastinading
besteading1446024bestea_ding
coattending1543544coattending
commanding1845924co_mmanding
contending1449124cont_ending
costarring1345394cost_arring
crossbanding18111984crossbanding
desanding12207654des__anding
disbanding1545584dis_banding
displanting1546044displanting
distancing1447084dist_ancing
distending1348334dist_ending
estranging1246024_estranging
garlanding1344434_garlanding
goaltending1451994goaltending
husbanding1742944hus_banding
instancing1344644inst_ancing
jostling16207124jostl___ing
landing92819324____landing
misbranding1744294misbranding
misplanning1653874misplanning
misplanting1645634misplanting
mistending1447954mist_ending
obtunding1354244_obt_unding
outadding1235794_out_adding
outdancing1445224_outdancing
outfinding1545874_outfinding
outflanking1943414_outflanking
outhandling1643464_outhandling
outlandish1452854_outlandish
outlasting1137524_outlasting
outlawing1337934_outla_wing
outlaying1338544_outla_ying
outleading1237134_outleading
outlining10310504_outlin_ing
outmanning1345544_outmanning
outplanning1463834_outplanning
outranging1238004_outranging
outranking1537674_outranking
outstanding1344554_outstanding
outwinding1545654_outwinding
pentlandite1451984pentlandite
pestling111010254pestl___ing
planing103418254p___lan_ing
planking153513014p___lanking
planning113610224p___lanning
planting113515384p___lanting
poinding122510004po___inding
pollening1236924po_llen_ing
pomading1437424po__ma_ding
ponding114317084po____nding
poniarding1443364po_niarding
populating1547664popula_ting
portaging1346844port_a_ging
portioning1347194portion_ing
portraying1645164portra_ying
positioning1454554position_ing
postediting1554454postediting
postfixing2343244post_fixing
postforming1953264postforming
posting105622244post____ing
postposing1555024post_posing
postprandial1761744postprandial
postulancies1652624postulancies
posturing1238994post__uring
pothunting1643654po_thunting
potlatching1952114po_tlatching
pounding123311474po___unding
preplanning1643694preplanning
preplanting1645934preplanting
pretending1438614pret_ending
prostaglandin177924prostaglandin_
prostaglandins187974prostaglandins
prostrating1449394prostra_ting
protending1446814prot_ending
pustulating1445244pustula_ting
relanding112110924__relanding
sanding93520604__s__anding
slanging103413434__s_langing
slanting94115094__s_lanting
standings11257154__st_andings
stanging104013654__st_anging
staning83922244__st_an_ing
steading103613594__stea_ding
stounding1136234__stounding
volplaning1642474volplan_ing

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit1488191018.76616976.8
3Display Results1011010.0631603.2
 (SQL Overall)1786911019.26519286.7
 
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.