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

97 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
pisolites114938(None) 
pisolite10310371pisolite_
pisoliths1443641pisoliths
iolites73819482_i_olites
isolates8613512_isolates
isolines8312302_isolines
picolines1339622picolines
pisolith1346552pisolit_h
pisolitic1347102pisolitic
absolutes1144523absolutes
aerolites9312583aerolites
biotites10310083bi_otites
bisulfites15152663bisulfites
cryolites1446963cryolites
desolates10311793desolates
diorites9313523di_orites
dislikes132810843dis_likes
disobliges1453073disobliges
disunites1088673disunites
epibolies1345123epiboli_es
epizoites2043693epizo_ites
essonites945153essonites
fishlines15246843fishlines
gasolines1047483gasolines
idolises938763_idolises
idolizes1837553_idolizes
illites72415013_i_llites
inosites8312793_inosites
insolates9311273insolates
iolite63221983_i_olite_
isoclines1146223_isoclines
isolate7313923_isolate_
isolated9410523_isolated
isoline7314013_isoline_
kiloliter1344013kiloliter
kiloliters1442933kiloliters
kilolitres1442723kilolitres
kryolites1643993kryolites
lepidolites1452413lepidolites
limonites1148003limonites
masonites1149173masonites
miscites12313783mis_cites
mislies92922283mis_li_es
mislikes143311833mis_likes
mislives132912153mis_lives
miswrites1447983miswrites
niccolites1444133niccolites
niobites1037313ni_obites
obsoletes1144213obsoletes
oolites72817843__oolites
ophiolites1544193ophiolites
pearlites1138233pearlites
pelites93821993p__elites
pemolines1348623pemolines
penlites10312273p_enlites
perlites10316363p_erlites
phonolites1547653phonolites
phyllites1745323phyllites
picholines1746303picholines
picoline12310853picoline_
picolins1239853picoli_ns
picrites121811083pi_crites
pigeonites1343903pigeonites
pilosities1247803pilosities
pinites9319533pi__nites
pinoles93418703pinol__es
piolets93513193pi_olet_s
piosities11311723pi_osities
pipelines13178353pipelines
pirogies1139423pirogi_es
pismires1235883pis_mires
pistes85325633pis___tes
pistoles102514723pistol__es
pistolier1146383pistoli_er
pistoliers1244583pistoliers
podites103014733p__odites
polices113118053p__olices
polies84034583p__oli_es
polite83625073p__olite_
politer92417073p__oliter
politest10312943p__olitest
polities102722343p__olities
posoles9314883posol__es
prolines102619693p_rolines
pusslies1036173pussli_es
pyrolizes2347233pyrolizes
resolutes968193resolutes
rhyolites1545033rhyolites
sepiolites1246013sepi_olites
solates73523853__solates
solutes73515263__solutes
somites94219123__somites
sopites93817173__sopites
sorites73825243__sorites
tillites8312833ti_llites
violates11311193vi_olates
zeolites1738383_zeolites

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit148641976.75022020.9
3Display Results97970.0462108.7
 (SQL Overall)178691977.23224708.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.