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

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

63 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
petites9382020(None) 
pelites93821991pelites
petite84320651petite_
apatites10311292apatites
appetites1347512appetites
betides104915262betides
betimes115114412betimes
betises94816122betises
cerites94823432cerites
elites66027122_elites
evites94916472_evites
jetties143613122jetties
lenites7818442lenites
metates92720012metates
patines95225762patines
patties93425142patties
pectates122213952pectates
pectines121914682pectines
pectizes21229782pectizes
peises84125042pe_ises
pelite84323002pelite_
penates93321592penates
penises9318192penises
penlites10312272penlites
peptides132610262peptides
peptizes21269852peptizes
peritus9311802peritus
perlites10316352perlites
petioles10311642petioles
petit74332652petit__
petted94121522pet_ted
petter83924772pet_ter
petters93722362pet_ters
pettier94213612pettier
pettiest103113962pettiest
pettitoes1144182pettitoes
pettles93916482pettles
pewits112810682pewit_s
peyotes1238482peyotes
pieties9419222pieti_es
pinites9319532pinites
pities83828082piti_es
podites103014732podites
poetises10313952poetises
poetizes19310252poetizes
potties93723542potties
pretties10615132pretties
putties94420022putties
pyrites12812202pyrites
ratites74920682ratites
recites93524582recites
resites74027792resites
reties65436192reti_es
retiles74426992retiles
retimes95020172retimes
retines75134672retines
retires74726212retires
retitles83612592retitles
tectites1039992tectites
tektites1236612tektites
velites103417302velites
verites103822262verites
yperites13310152yperites

Search took 4 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 Filter1786911076710.1261418182.5
2DLD Change Limit107671633.45331181.9
3Display Results63630.0163937.5
 (SQL Overall)178691633.59549705.4
 
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.