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

78 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
pegbox184401(None) 
pegboxes2043142pegboxes
teabox1536012teabox
bebop11410793be_bop
begot84625953beg_ot
box1210142343___box
detox13310953de_tox
ebon66821103_e_bon
ego46726053_eg_o_
egos55821653_eg_os
elbow10117703_elbow
embow1297563_embow
feedbox2052663feedbox
fogbow1544783fogbow
gearbox1742953gearbox
gox117137183__g_ox
hatbox1835133hatbox
hellbox1944983hellbox
hotbox1835693hotbox
icebox1753083icebox
jerboa1535633jerboa
kebob135110923ke_bob
legion75712983legion
lesbo739253lesbo_
lesbos837403lesbos
outbox1537463outbox
pageboy1543873pageboy
pagod95013683pag_od
pebble1238003pebble
pebbly1545083pebbly
pedro8313153pedro_
pedros9312183pedros
peg65843063peg___
pegboard1444803pegboard
pegged114811903pegged
pegs75531763peg__s
pekoe114612363pe_koe
pelon74423213pe_lon
pengo84317593pengo_
pengos94612413pengos
pennon8310643pennon
peon65635243pe__on
peplos101211543peplos
pepo87622153pe_po_
pepos96620083pe_pos
pereon83517453pereon
period9314983period
pernod9310453pernod
peroxy1838243pe_roxy
perron83216623perron
person83517873person
peso66925823pe_so_
pesos77221623pe_sos
pesto75723723pesto_
pestos84719083pestos
petrol82714063petrol
petto76021043petto_
phlox1737333p_hlox
pigboat1247823pigboat
pigeon949413pigeon
pillbox1843413pillbox
poboy121612223p_oboy
pogrom1138593pogrom
postbox1885493postbox
potboy1397813potboy
pox126140693p___ox
rebop9313283re_bop
redox134714233re_dox
region74614903region
reglow10339403reglow
regrow10309883regrow
segno64814743segno_
segnos73610443segnos
sego56525183seg_o_
segos64919483seg_os
skybox2242293skybox
unbox1438753_unbox
xerox1138623xe_rox

Search took 7 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.203880251.2
2DLD Change Limit112716786.51617298.3
3Display Results78780.0332363.6
 (SQL Overall)178691786.75226464.9
 
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.