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

51 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
wipeout128787(None) 
wideout1179031wideout
wipeouts1354201wipeouts
hideout1179792hideout
timeout948592timeout
whiteout1445582whiteout
wideouts1275232wideouts
without1348882without
copout10418783cop_out
dimout9414243di_mout
diplont10311693diplont
fadeout11410193fadeout
hideous1168433hideous
hideouts1285573hideouts
linecut997983linecut
missout9412663missout
niveous1037193niveous
piceous11310693piceous
pigout9314613pi_gout
pileous9510523pileous
pipeful1445643pipeful
pipet95533323pipe__t
piteous9310683piteous
pout65752553__p_out
ripest84317943ripe_st
ripost83615003rip_ost
sickout1359373sickout
slipout949083slip_out
spinout9311583spinout
spout75029633_sp_out
sprout8419403_sprout
takeout1149873takeout
timeous938403timeous
timeouts1044773timeouts
viperous1347613viperous
walkout1447933walkout
washout13410133washout
whiteouts1543173whiteouts
widest104517003wide_st
wigeon1037223wigeo_n
wigeons1136983wigeons
wipe94830283wipe___
wiped114722083wipe__d
wiper105421293wipe__r
wipers115416083wipe_rs
wipes104827083wipe__s
wiseguy1442353wiseguy
wisent93516343wise_nt
wisest95016443wise_st
withouts1445123withouts
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.403443402.0
2DLD Change Limit134027516.55020462.1
3Display Results51510.0133923.1
 (SQL Overall)178691516.96625651.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.