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

88 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
shippon1428580(None) 
shippen14298861shippen
shippons15255661shippons
hippo12369062_hippo_
hippos13408432_hippos
shipman14247132shipman
shipmen14317282shipmen
shipped153312102shipped
shippens15316802shippens
shipper143514042shipper
shipping163611252shipping
siphon1138462s_iphon
chiffon1844053chiffon
chignon1344623chignon
chipped174110813chipped
chipper163912583chipper
chippie16297693chippie
chipping18389793chipping
chippy18437613chipp_y
chiton112612393chi_ton
gipon84212413_gi_pon
happen134812193_happen
hipbone1445923_hipbone
hipped144317693_hipped
hipper133818023_hipper
hippie132811243_hippie
hipping153915103_hipping
hippy155112793_hipp_y
kippen14299013_kippen
lippen103911403_lippen
pippin92810303_pippin
scion72214993sci__on
shampoo1435373shampoo
shapen114414653sh_apen
sharpen12389723sharpen
shilpit1247103shilpit
shin75634313shi___n
shinbone1354473shinbone
ship95228243shi_p__
shipborne1652843shipborne
shiplap1444513shiplap
shipload1464343shipload
shipment15217593shipment
shippers153012313shippers
shippings17275683shippings
ships105123773shi_p_s
shipway1844213shipway
shipworm1843793shipworm
shoon84022013sh__oon
shopboy1743803shopboy
shopman14247263shopman
shopmen14277203shopmen
shoppe133110323shopp_e
shopped153512213shopped
shopper143312633shopper
shoppes143411393shoppes
shopping163611293shopping
shopworn1643983shopworn
simoon858063s_imoon
siphons1239353s_iphons
sipped113720633s_ipped
sipper103920993s_ipper
sippet103519393s_ippet
sipping123117433s_ipping
skipped16358413skipped
skipper15339573skipper
skippet15288463skippet
skipping17297603skipping
slipped124711743slipped
slipper113712983slipper
slipping133510663slipping
slippy1375843slipp_y
snipped123510043snipped
snipper113911333snipper
snippet113310433snippet
snipping13308853snipping
snippy1374843snipp_y
soupcon1144163soupcon
spoon74719443s__poon
stepson945673stepson
stipple1146623stipple
swipple1444633swipple
syphon1436853s_yphon
whipped18379333whipped
whipper173611383whipper
whippet17328843whippet
whipping19328173whipping
whippy19385843whipp_y

Search took 7 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.403443402.0
2DLD Change Limit134027886.54620474.6
3Display Results88880.0332666.7
 (SQL Overall)178691886.98225593.1
 
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.