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

76 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
fissiped144415(None) 
fissipeds1542421fissipeds
filliped1435222filliped
fissile10269652fissile_
fissioned1345522fissioned
fissured1235182fissured
gossiped1263512gossiped
bishoped1644663bishoped
cirriped1344183cirriped
cissies94116153cissi_es
discipled1545673discipled
disliked14288553disliked
dissaved1337313dissaved
dissed85220183diss__ed
disseised1147863disseised
disseized2046323disseized
dissipated1446053dissipated
fessed104515063fess__ed
finished1536483finished
fished134316313fi_s_hed
fishier13359853fishi_er
fissate103010033fissate_
fission1038733fissi_on
fissions1138033fissions
fissure1036783fissure_
fissures1136573fissures
fisted104218703fi_s_ted
fossicked1942533fossicked
fussed104613803fuss__ed
fussier103610673fussi_er
gipsied1135873gipsi_ed
gossiper1164203gossiper
gossipped1552323gossipped
gussied9267193gussi_ed
hissed104114453hiss__ed
hissier103410503hissi_er
hissies103915823hissi_es
insipid1044513_insipid
issued746723_iss_ued
kissed114412853kiss__ed
lisped94113423li_s_ped
midsized2144733midsized
milliped1337383milliped
misaimed1338093misaimed
miscited13310423miscited
misfiled14278653misfiled
misfired14238543misfired
misliked15319513misliked
mislived14328783mislived
missed94423603miss__ed
misshaped1744753misshaped
missies93423983missi_es
missile92815403missile_
missiles103015083missiles
missioned1248603missioned
missises103513693missises
missive122413143missive_
missives133212843missives
misspend1345243miss_pend
missuited1257023missuited
mistimed1339123mistimed
mistyped1685173mistyped
pinniped1343853pinniped
pissed94816933piss__ed
siped84927683___siped
sissier73711363sissi_er
sissies73716603sissi_es
sissified1345543sissified
sliped95417063__sliped
sniped94913483__sniped
stiped94517073__stiped
swiped123811093__swiped
tissued835583tiss_ued
visited1168773vi_sited
wisped123411893wi_s_ped
wissed104114643wiss__ed

Search took 9 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.436409841.7
2DLD Change Limit146162767.61019206.6
3Display Results76760.0332303.0
 (SQL Overall)178691768.07922118.0
 
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.