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

94 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
labourer104575(None) 
laborer9249501labo_rer
laboured1156321laboured
labourers1144711labourers
tabourer1035741tabourer
abjurer1634742_abjurer
favourer1443822favourer
labored102810242labo_red
laborers10208382labo_rers
labour84210932labou__r
labours9349882labour_s
savourer1134472savourer
taborer9269292tabo_rer
taboured1156272taboured
tabourers1144672tabourers
tabouret1049172tabouret
tambourer1343492tambourer
vapourer1344262vapourer
abhorrer1343383_abhorrer
abjure1536733_abjure_
abjured1735073_abjured
abjurers1733943_abjurers
abjures1636513_abjures
aborter939923_aborter
absurder11134353_absurder
abuser85413683_ab_user
adjurer1534803_adjurer
adorer74713443_ado_rer
allurer7348433_allurer
arboured1156253arboured
armourer1054883armourer
arouser74514423_arouser
assurer767783_assurer
augurer8136343_augurer
belaboured1542273belaboured
borer75131273__bo_rer
capturer1246083capturer
carouser1068843carouser
clamorer1236903clamo_rer
clamoured1444063clamoured
colourer1037553colourer
devourer1235063devourer
dourer74215273__dourer
favorer1355883favo_rer
favoured1533963favoured
favourers1543123favourers
flavorer1454553flavo_rer
flavoured1642973flavoured
glamoured1343183glamoured
harborer1348053harbo_rer
harboured1544313harboured
honourer1146243honourer
jabberer1944023jabberer
labeler92310183lab_eler
labeller10248073labeller
labor75117313labo___r
labors84016403labo_r_s
labouring1236213labouring
labret8320223lab__ret
lacquer18135153lacqu_er
lacquerer2043243lacquerer
larruper1042743larruper
latherer111310443latherer
lauder73815013la__uder
laurel649033la__urel
layover1334433layo_ver
lecturer10136023lecturer
louder74414603l__ouder
loured74617403l__oured
louver94110393l__ouver
lurer54625313l___urer
manurer938583ma_nurer
maturer938973ma_turer
pasturer1037523pasturer
pourer84516043__pourer
savorer1057883savo_rer
savoured1234793savoured
savourers1243833savourers
savourier1242973savourier
scourer93910433_scourer
sourer63620213__sourer
tabored102810563tabo_red
taborers10268333tabo_rers
taboret92916113tabo_ret
tabouleh1342793tabouleh
tabour84011313tabou__r
tabourets1144163tabourets
tabours94110073tabour_s
tamboured1443783tamboured
tambourers1442743tambourers
tourer64115073__tourer
vaporer1236983vapo_rer
vapoured1434353vapoured
vapourers1443373vapourers

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162948.81316584.8
3Display Results94940.0462043.5
 (SQL Overall)178691949.02919790.8
 
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.