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

70 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
ranchmen154583(None) 
ranchman1546041ranchman
henchmen1844452henchmen
ranched133113602ranch_ed
rancher123013632ranch_er
ranches123620112ranch_es
watchmen1844752watchmen
acumen1049013_a_cumen
anchormen1644353_anchormen
ashmen1168173_a_shmen
bandsmen1356453bandsmen
branched163210453branch_ed
branches153613803branch_es
branchier1637133branchier
branchlet1647183branchlet
catchment1846293catchment
coachmen1745013coachmen
cranched163210413cranch_ed
cranches153114543cranch_es
dutchmen1643163dutchmen
earthmen1346393earthmen
grantsmen1294643grantsmen
hackmen1836713ha_ckmen
handymen1744983handymen
hangmen1337373han_gmen
hatchment1945313hatchment
henchman1844003henchman
landmen1038553lan_dmen
landsmen1156603landsmen
larchen12479623larch_en
manche133515103manch_e_
manches143818623manch_es
manchet143317773manch_et
marchen143312073march_en
packmen1746313pa_ckmen
parchment1846913parchment
pitchmen1744333pitchmen
raceme1039733ra_ceme_
racemed1237013ra_cemed
racemes1139093ra_cemes
rachet115028973ra_ch_et
radiomen1146633radiomen
raftsmen1343953raftsmen
ragmen93712183ra__gmen
ramen75625193ra___men
rance75028513ranc__e_
rances84625443ranc__es
ranch105019793ranch___
ranchero13277423ranchero
ranchers133311793ranchers
ranching141712043ranching
ranchless1444453ranchless
rancho114310853ranch__o
ranchos123911393ranch_os
rancored1137223rancored
ransomed1146933ransomed
ransomer1047883ransomer
ratches123620463ratch_es
ratchet124218333ratch_et
raunches1368053raunch_es
raunchier1443713raunchier
richen113812513r_ich_en
sandmen1039413san_dmen
trackmen1635573tra_ckmen
tranche123312223tranch_e_
tranches132915513tranch_es
trashmen1346563tra_shmen
vanmen1138403van__men
watchman1844623watchman
yachtmen1842433ya_chtmen

Search took 9 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.1561145455.1
2DLD Change Limit146162707.95318378.2
3Display Results70700.0332121.2
 (SQL Overall)178691708.14221946.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.