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 “housebreakers” with Change Limit: [1] [2] [3] [4] [5] [6]

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

58 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
housebreakers226213(None) 
housebreaker2162431housebreaker_
housebreaks2052582housebreak__s
houseboaters1752473houseb_oaters
housebreak1952733housebreak___
housebreaking2361773housebreaking
housebreakings2471343housebreakings
groundbreakers22121134groundbreakers
heartbreakers2261454heartbreakers
houseboater1652914houseb_oater_
housebroke1952544housebr_oke__
housebroken2061814housebr_oke_n
housedresses1652704housedresse_s
housekeepers2192374house_keepers
icebreakers1952194__icebreakers
tiebreakers1752564__tiebreakers
backbreakers21142055_backbreakers
boilermakers20111725boile_rmakers
breakers143810975_____breakers
casebearers1552275_caseb_earers
doublespeakers2371085doublespeakers
groundbreaker21121135groundbreaker_
heartbreaker2161695heartbreaker_
homemakers2144665ho_me__makers
homesteaders1851925ho_mesteaders
honeyeaters1752905ho_ne_yeaters
horsebeans1583635horseb_ea__ns
horsefeathers2261195horse_feathers
horseplayers2051745horse_players
horseraces1546055horse_r_ace_s
houseboats15144505houseb_oa__ts
housecleaned1861405housecleane_d
housecleans1662135houseclea__ns
housedress1443325housedr___ess
housefathers2151825house_fathers
householders1952855house_holders
housekeeper2082545house_keeper_
housekeeps1952655house_ke__eps
houseleeks1753065house_le__eks
housemasters17153625house_masters
housemates1546145house__mate_s
housemothers2062085house_mothers
housepainters1861125housepainters
housewares1645425house__ware_s
icebreaker1852245__icebreaker_
jawbreakers2761745__jawbreakers
lawbreakers2062075__lawbreakers
loudspeakers1961045lou_dspeakers
mouthbreeders2112825mouthbreeders
noisemakers1752705noise__makers
nonspeakers17113115nons__peakers
outbreaks1544075_ou_tbreak__s
overeaters1348635_o_ve_reaters
streakers13218135___s_treakers
strikebreakers1981175strikebreakers
tiebreaker1652655__tiebreaker_
trailbreakers1961475trailbreakers
windbreakers2261655_windbreakers

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790589.04613795.0
3Display Results58580.0461260.9
 (SQL Overall)178691589.48218845.3
 
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.