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

82 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
warthog144454(None) 
warthogs1544831warthogs
altho86312603_altho_
archon11311753_archon
author939763_author
barhop13319643bar_hop
bathos116215633ba_thos
cantdog1134573cantdog
carhop133610763car_hop
carting104228283carting
carton84522663cart_on
cartoon94114463cartoon
cartop104213563cart_op
darting94020663darting
earshot10410833earshot
earth85023053earth__
earthed1139923earthed
earthen1039253earthen
earthing12310333earthing
earthly13387383earthly
earths95014593earth_s
earthy12399943earth_y
farther1348343farther
farthing1538073farthing
farting114120753farting
fathom1437473fa_thom
garth94720223garth__
garths104111503garth_s
karting123716063karting
marathon1346823marathon
markhor1635463markhor
marting103325013marting
narthex1734263narthex
ortho8312293_ortho_
parting103527383parting
parton84720993part_on
partook1337313partook
pathos115516693pa_thos
sandhog1275453sandhog
sartor6313883sart_or
swarth126012083swarth__
swarths13537323swarth_s
swarthy16466373swarth_y
tarting84222653tarting
tautog765713taut_og
wafting143911663wafting
wahoo112413083wa__hoo
waiting113618953waiting
waitron1036333waitron
wanting114220173wanting
wanton94413813want_on
warding123918143warding
waring105029443war_ing
warison1037083warison
warking153519573warking
warming133515083warming
warmth1477933warmth__
warmths1583783warmth_s
warning113717093warning
warping133715183warping
warring113717973warring
warrior1045363warrior
warship1547843warship
wart77866083wart___
warted104223233wart_ed
wartier103413913wartier
wartime1237743wartime
warts814840403wart__s
warty119323823wart__y
wasting114422843wasting
watchdog1842243watchdog
watthour1442893watthour
worth117120523worth__
worthed1437873worthed
worthing15178053worthing
worths127812893worth_s
worthy15598803worth_y
wrath115715873wrath__
wrathed14298523wrathed
wrathing15248923wrathing
wraths123810083wrath_s
wrathy15377853wrath_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.406440125.6
2DLD Change Limit134027826.48620664.0
3Display Results82820.0302733.3
 (SQL Overall)178691826.92225814.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.