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

66 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
without134888(None) 
withouts1445111withouts
pitchout1546942pitchout
washout13410132washout
watchout1647002watchout
whiteout1445582whiteout
wideout1179032wideout
wipeout1287872wipeout
beshout12311833beshout
citrous93112983citrous
cutout8315923cut_out
dimout9414243di_mout
hideout1179793hideout
lithest10513913lithest
lithium1245823lithium
litho86513783litho__
lithoed1137833lithoed
lithoid1148773lithoid
lithops12307253lithops
lithos94212553litho_s
mahout11415803_mahout
missout9412663missout
nitrous73512483nitrous
outshout1149483outshout
pigout9314613pi_gout
pitchouts1643663pitchouts
piteous9310683piteous
putout8315113put_out
setout64719463set_out
shout85433163__shout
sickout1359373sickout
stout57434053_st_out
thou76722213__thou_
thous86017253__thous
timeout948593timeout
tout46753823__t_out
trout57332573__trout
walkout1447933walkout
washouts1445903washouts
watchouts1744033watchouts
watthour1442883watthour
whiteouts1543173whiteouts
whort114623693w__hort
wideouts1275233wideouts
wight123725573wigh__t
wipeouts1354203wipeouts
wishful1664503wishful
with105730473with___
withal1238933with_al
withe115220233with__e
withed134416233with_ed
wither124321353with_er
withers134417753withers
withes124620843with_es
withhold1843433withhold
withier132910493withier
withies133913543withies
withiest142411243withiest
within123611383with_in
withing143814493withing
withins133511693withins
withy144813763with__y
witloof1344353witloof
wittol935923witto_l
wittols1035733wittols
workout1448393workout

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.1731032896.0
2DLD Change Limit134027667.54617761.3
3Display Results66660.0302200.0
 (SQL Overall)178691667.74923059.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.