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 “tiptoee” 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
tiptoe838281tipto_e
tiptoed1036141tiptoed
tiptoes939171tiptoes
tiptop1036102tipto_p
tiptops1136072tiptops
biotope1146623biotope
citole8311503ci_tole
diploe9810153diplo_e
diploes101111493diploes
dipole91112853dip_ole
distome10313233distome
dittoed936733dittoed
epitome1157743epitome
epitope1147053epitope
giftee103512083gift_ee
heptose1237493heptose
hipbone1445923hipbone
histone10312843histone
intone61115443_intone
listee64223063list_ee
peptone11310763peptone
picotee11311473picotee
pintoes95117713pintoes
pistole92414313pistole
riptide1036893riptide
taphole1239773taphole
tepee74724213tep__ee
testee64323303test_ee
tictoc1036003ticto_c
tictocs1145903tictocs
tilted74616863tilt_ed
tilter63417693tilt_er
tinstone848183tinstone
tinted74419533tint_ed
tinter63923643tint_er
tintype1243033tintype
tipoff1436383tip_off
tipped114418263tip_ped
tipper103918413tip_per
tippet103917873tip_pet
tippier113210543tippier
tipple103411913tip_ple
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
tippytoe1551403tippyto_e
tippytoed175973tippytoed
tippytoes1651583tippytoes
tipsheet1345833tipsheet
tipsier9268893tipsier
tipster9299053tipster
tipstock1643733tipstock
tiptoeing1242713tiptoeing
titer55430613ti_t_er
titfer9409523ti_tfer
tithe85319703ti_t_he
tithed104115593ti_thed
tither94920283ti_ther
tithes94720213ti_thes
title54721073ti_t_le
titled73815003ti_tled
titles63719923ti_tles
titmen8239883ti_tmen
titre54619393ti_t_re
titres64718933ti_tres
titter63421163ti_tter
tittie63213153ti_ttie
titties73617363titties
tittle63613333ti_ttle
tittles73413263tittles
topee76029953top__ee
topstone1046883topstone
triptane1047573triptane
tritone73613893tritone
tutee5423523t_ut_ee
typhose1546693typhose
uptore8279453_uptore
yippee132810743yip_pee

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 Filter1786911340270.406440125.6
2DLD Change Limit134027786.61020276.4
3Display Results78780.0136000.0
 (SQL Overall)178691787.02925422.0
 
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.