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

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

103 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
tripolis103871(None) 
tripoli937131tripoli_
propolis12311402propolis
triols66117802tri_ol_s
triples94616872trip_les
triploid1147362triploid
triploids1245892triploids
tripodic1345332tripodic
tripodies1246572tripodies
tripods10359052tripo_ds
tripos84014922tripo__s
triposes1039972triposes
acropolis1346453acropolis
adiposis1146253adiposis
aiolis6316843_ai_olis
bricoles122610303bricoles
brocolis1247303brocolis
cipolin1148783_cipolin
cipolins1238033_cipolins
crapolas1247403crapolas
cripples14298403cripples
dipoles101013753_dipoles
frijoles1834373frijoles
frivols1334743frivol_s
metropolis1456463metropolis
orioles7412993ori_oles
polis74731163___polis
repolish1347933_repolish
repolls939053_repolls
ripoffs1543383_ripoffs
riposts9279403_riposts
ripples113513293_ripples
tadpoles1135953tadpoles
thiolic1247323thi_olic
thiols95112763thi_ol_s
tipis76019923t_ip__is
tipoffs1543033t_ipoffs
tipples112811253t_ipples
travois1037883travo_is
trefoils1145303trefoils
trellis739873tr_ellis
tremolos1046043tremolos
trials64319883tri_al_s
triazoles1844393triazoles
tribalism1347893tribalism
tribalist1149953tribalist
tribals9610753tribal_s
trichosis14106443trichosis
trickles143013763trickles
tricolor10115833tricolor
tricolors11125803tricolors
tricorns1036683tricorns
tricots9311563trico_ts
trifles103814833tri_fles
trifold1136243trifol_d
trifolium1443243trifolium
trifoliums1552473trifoliums
triforia1145653triforia
trigons84312093trigo_ns
trigos74214173trigo__s
trills64319853tri__lls
trilogies1048173trilogies
trindles93211693trindles
triodes84012503tri_odes
triol55521363tri_ol__
triolet73219523tri_olet
triolets83410143tri_olets
trios55528093tri_o__s
trioses75015653tri_oses
trioxid1546613tri_oxid
trioxids1644443tri_oxids
tripacks1664893tripacks
tripes85324873trip__es
triple84215923trip_l_e
tripled104113833trip_led
triplet94319213trip_let
triplets103510263triplets
triplex16447803trip_lex
tripling112712553trip_ling
triplite1039103trip_lite
triplites1148283trip_lites
triploidy1543683triploidy
triply114211023trip_l_y
tripod9399853tripo__d
tripodal1145143tripodal
tripody13395983tripo_dy
trippers123210163trippers
trippets12357423trippets
trips74923363trip___s
triptans1047363triptans
trisomes1039833trisomes
trisomic1245943trisomic
trisomics1343853trisomics
trisomies1147163trisomies
tritomas1048033tritomas
tritones83413443tritones
tritons73814883trito_ns
trois57226093tr__o_is
trolls64613943tr__olls
tropeolin1145743tropeolin
tropeolins1245333tropeolins
troponin1047943troponin
troponins1147203troponins

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621037.17320376.7
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.