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

99 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
displace134865(None) 
displaced1546791displaced
displacer1446431displacer
displaces1448591displaces
misplace1437551misplace
disgrace1248282disgrace
displacers1545012displacers
displant11412222displant
display1336662displa_y
displayed1645882displayed
displayer1545832displayer
displays1446292displays
displease1245522displease
displode1247642displode
displume1344802displume
misplaced1646252misplaced
misplaces1537952misplaces
airplane1067793airplane
airspace1244653airsp_ace
anyplace1543853anyplace
biplane1139033bi_plane
deplane10311413d_eplane
desolate9411993desolate
diallage1045233diallage
dilate73220693di__late
dimple113512793dimpl__e
dioptase1145513dioptase
diphase1387273di_phase
diploe9810153di_pl_oe
discalced1545653discalced
discase102912863dis_case
disclaim1345643disclaim
disclike15208653disclike
disclose1148743disclose
disease83213843dis_ease
disgraced1446743disgraced
disgracer1346183disgracer
disgraces1348453disgraces
dishlike16287893dishlike
dishware1545433dishware
disklike12206743disklike
dislike122913453dis_like
disparage1346203disparage
disparate1249053disparate
dispart101115283disp_art
dispatch1654553dispatch
dispense11129783dispense
disperse111011353disperse
displacing1646413displacing
displanted14126633displanted
displants1248073displants
displayers1654823displayers
displeased1444483displeased
displeases1345683displeases
disploded1446543disploded
displodes1347863displodes
displumed1544353displumed
displumes1444983displumes
dispose10312763disp_ose
dispraise1248343dispraise
disprize2048433disprize
disprove14138193disprove
dispute1039083disp_ute
disrate81418523dis_rate
dissave1139413dis_save
dissuade1065933dissuade
distance11311853distance
distract11313023distract
disulfate13145713disulfate
disvalue1244433disvalue
emplace1338263_emplace
fireplace1644873fireplace
fishplate1743163fishplate
inlace82513043_i_nlace
isolate7313923_isolate
midspace1543953midsp_ace
mispage12310523misp_age
misplan1147773mispla_n
misplans1238863misplans
misplant12410763misplant
misplay1436383mispla_y
misplayed1745303misplayed
misplays1555543misplays
misprice1448133misprice
misspace1446523misspace
mistrace12312643mistrace
noplace1137393_noplace
outplace1257913outplace
place94824613___place
preplace1488983preplace
replace113214283_replace
respace11310913resp_ace
resplice1237253resplice
solace83415823__solace
space95325673__sp_ace
splake1259783__splake
splice104915103__splice
tinplate1047743tinplate
wisplike1734713wisplike

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 Filter1786911461620.453394461.4
2DLD Change Limit146162996.98320931.1
3Display Results99990.0462152.2
 (SQL Overall)178691997.48223882.8
 
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.