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

101 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
pishoge133669(None) 
pishoges1446951pishoges
pishogue1442831pishogue
piehole12188552piehole
pinhole122010432pinhole
pishogues1543002pishogues
pistole92414312pistole
airhole1048273airhole
ashore9414613_ashore
asshole1046793asshole
bishop1336943bisho_p
bishoped1644663bishoped
bishops1437033bishops
disgorge1145733disgorge
dislodge1145173dislodge
dispose10312763dispose
disrobe1038993disrobe
distome10313233distome
disyoke1546233disyoke
episcope1445833episcope
episode1056303epis_ode
episome1157813epis_ome
epistome1246263epistome
fishbone1644663fishbone
fisheye1644773fisheye
fishpole1644053fishpole
histogen1245563histogen
histone10312843histone
inshore1038723inshore
isagoge943933_isagoge
kishke1254273kish_ke
lissome937583lissome
mischose1547263mischose
miscode12310413miscode
misdone10310863misdone
mislodge1244113mislodge
mismove1437083mismove
mispage12310523mispage
misyoke1635823misyoke
oilhole1046263oilhole
onshore10310013onshore
passage1039803passage
pathogen1446463pathogen
pesthole1347553pesthole
phage115113673p__hage
phone105621933p__hone
pieholes13168913pieholes
pierogi1054723pierogi
pillage103412603pillage
pilose84514243pi_lose
pinbone1138183pinbone
pinholes131810663pinholes
pinole83218783pi_nole
pipage1199143pi_page
pipeage1236203pipeage
pirog83913673pi_rog_
pirogen1038263pi_rogen
pirogi9299013pi_rogi
pirogue1045413pi_rogue
piscine11610973piscine
pisco96314983pisco__
piscos105112593pisco_s
pish96127913pish___
pished124817063pish_ed
pisher114317753pish_er
pishers123815753pishers
pishes114722103pish_es
pishing134314373pishing
pismire1135353pismire
piso66727563pis_o__
pisos76021063pis_o_s
pissoir945043pissoir
piste75824603pis__te
pistol83313333pisto_l
pistoled11259593pistoled
pistoles102514723pistoles
pistols93213983pistols
piston83515923pisto_n
pistons93016373pistons
pistou83211843pisto_u
pistous92714383pistous
posole8314223pos_ole
postage103214853postage
posthole1339533posthole
pothole12312173pothole
psoae74411623p_s_oae
pushover1643083pushover
reshoe92816483resho_e
reshone102414163reshone
rissole739783rissole
shoe75933443__sho_e
shog86025143__shog_
shogi95014013__shogi
shogs95319713__shogs
shone83725983__shone
shore85432653__shore
shote85526103__shote
shove114421043__shove
visage1049083vis_age
viscose1237863viscose
wishbone1644293wishbone

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.423422437.4
2DLD Change Limit1340271016.96619240.2
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.42224075.9
 
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.