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

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

73 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
powwow134283(None) 
bowwow1334461bowwow
powwows1442851powwows
bowwows1454122bowwows
kowtow1643462kowtow
powwowed1641692powwowed
borrow114310723borrow
bowpot13410073bowpot
bowwowed1642173bowwowed
cowboy1637063cowboy
cowpox2035003cowpox
doowop1283853doowop
downbow1653393downbow
fogbow1544783fogbow
follow124010353follow
hollow124212663hollow
kotow12528713ko_tow
kowtows1742763kowtows
lowboy1435903lowboy
lowbrow1543273lowbrow
lowdown1454483lowdown
morrow113510093morrow
nohow1137293no_how
oxbow1734443_oxbow
pawnor11357243pawnor
pawpaw1653503pawpaw
pillow113110573pillow
plow95923233p__low
plowboy1743183plowboy
poboy121612223po_boy
poco86826153po_co_
podsol946853podsol
podzol1835083podzol
pogrom1138593pogrom
poison8312223poison
polio75722553polio_
polios84019723polios
polo66236633po_lo_
polos76129913po_los
polyol1138713polyol
pomo85828453po_mo_
pomos95321583po_mos
pompom1436493pompom
pompon1238943pompon
ponton83217643ponton
poo57757113po__o_
pood75934323po__od
poof95541663po__of
pooh96027383po__oh
pool65835953po__ol
poon67341263po__on
poop86532813po__op
poor65630223po__or
poos65949113po__os
porno75120653porno_
pornos85015253pornos
postop10511943postop
potboy1397813potboy
pothos114214693pothos
potion84519573potion
potto75320943potto_
pottos84615873pottos
pow87147283p___ow
powder123611903powder
power105325953po_wer
powers113822323powers
pows95537663po_w_s
powter114116033powter
powwowing1741873powwowing
poyou102611523po_you
prow97030383p__row
sorrow9339443sorrow
wow96643473___wow

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 Filter1786911127160.393454684.5
2DLD Change Limit112716735.56020272.7
3Display Results73730.0164562.5
 (SQL Overall)178691735.96929936.5
 
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.