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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
wheeps1443995(None) 
cheeps135312911cheeps
weeps104120561w_eeps
wheels123811721wheels
wheens124610611wheens
wheep136214351wheep_
whelps14437841whelps
beeps95320972_beeps
bleeps10499102bleeps
cheaps134613682cheaps
cheeks154712782cheeks
cheep125416502cheep_
cheers114518912cheers
creeps104213622creeps
deeps84921772_deeps
ghees95215552ghee_s
heaps105223222_heaps
heeds95420422_heeds
heels85625532_heels
helps105219342_helps
hemps126917332_hemps
jeeps144715372_jeeps
keeps116020282_keeps
kreeps12427412kreeps
neeps75617882_neeps
peeps95822362_peeps
seeps74828752_seeps
sheens95116992sheens
sheep105321522sheep_
sheers94322402sheers
sheets93918502sheets
shleps114710332shleps
sleeps83913322sleeps
steeps85215192steeps
sweeps114110512sweeps
thesps11448262thesps
threeps12687042threeps
veeps104715722_veeps
weeds95222212w_eeds
weeks125017862w_eeks
weens85224052w_eens
weep95131652w_eep_
weepy134212592w_eepy
wees76249122w_ee_s
weets85427722w_eets
whaps135115162wh_aps
whaups14405752whaups
wheals124512522wheals
wheats125013222wheats
whee105429592whee__
wheel115515342whee_l
wheen115016052whee_n
wheeped16387512wheeped
wheeple1534872wheeple
wheeples1634752wheeples
wheeze21276822wheeze
wheezes22306812wheezes
wheezy24244522wheezy
whelks16367322whelks
whelms14377572whelms
whelp136012092whelp_
whenas124610462whenas
whens114618762wh_ens
whereas13448902whereas
wheres125917442wheres
whets115019612wh_ets
whews145114492wh_ews
wheys145911552wh_eys
whips134917082wh_ips
whomps16457602whomps
whoops14487862whoops
whops135013932wh_ops
whumps16427092whumps
whups134210002wh_ups

Search took 3 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 Filter178691825510.356501941.0
2DLD Change Limit82551742.40634310.5
3Display Results74740.0164625.0
 (SQL Overall)178691742.77864323.6
 
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.